ADF’s Wrangling Data Flow (Power Query)– How do you get matched rows from the two data sources using Inner Joins?

In this blog, we will learn how to get matched rows from the two data sources using inner join in ADF’s Wrangling Data Flow step by step.

Step 1: Add a Power query flow as per the below screenshot.

Step 2: In the New power query give the proper power query name and add the data source that you want to merge. Here I am adding two datasets named “DS_EMP1” and “DS_EMP2”, both data sources have employee information.

Step 3: By default, the UserQuery will point to the first dataset query. All the transformation should be done on the UserQuery.

Step 4: Now click on Merge queries to merge your dataset.

Step 5: select a table and matching columns to create a merge table, here I have select EmpID as a common key to merge the data, and the join kind will be “Inner”.

Step 6: Once you click the OK button, you got a warning “Nested join must be expanded”.

Step 7: Click on expand dataset button to expand your result and select columns whatever you want from the other data source, here in my case both the datasets have the same column name so I deselect all the columns from the result dataset.

Step 8: Now the UserQuery will show the matched rows, that’s all you need to do to get matched rows in two data sources.

Hope this will help.