cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Trish00
Microsoft
Microsoft

Is it possible to join two different DataSource's to a table?

I have a table which is pulling data from one source, and I want to add another column from two other data sources.

 

Is this possible if so, any guidance would be appreciated.

3 REPLIES 3
eka24
Super User
Super User

You would use the AddColumns and LookUp functions to do that.

Kindly show a sample screen shot of the tables and the expected result.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Please Subscribe to my Youtube Channel

Two tables, two different data sources. 

 

Expected result would be to join the status and reason table along with the data to the ID and Name table.

 

ID

Name

 

 

 

 

 

 

 

 

 

Status

Reason

 

 

 

 

 

 

Do the 2 tables have any common column? The screen shot does not indicate that.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,437)