Forum Discussion

KBD's avatar
KBD
Helper III
1 year ago

Power Query merge query on two colums

Hello:

I have two datasets (UserQueries) in Power Query, I now want to merge them on two columns that are common. Should be easy, right.

I use Merge Queries on the tool bar, get a dialogue box as follows:

 

 

The col's are correct and the order is correct. Number of matches is correct.

Now I have a Merged Queries step with code as follows:

SQLCopy
 
Table.NestedJoin(#"Added custom 6", {"ASSETNUM", "recordTag"}, UserQuery, {"ASSETNUM", "AssetMax"}, "UserQuery", JoinKind.Inner)

But I get the following error:

UserQuery (2) : Expression.Error: Nested Joins must be expanded.

 

Please note I am doing this workin Power Query in a Data Factory pipeline.

 

Googling this error did not return any helpful results.

Your kind assistance is requested

KD

Need Help

3 Replies

  • ronrsnfld's avatar
    ronrsnfld
    Super User
    1 year ago

    This error is likely because one of your queries includes a column which consists of tables, probably created by a previous join. But your screenshot is not useful for re-creating your problem. If you do not have a joined table column in either of your source queries, please provide sufficient data so that your issue can be reproduced, either as text which can be copy/pasted, or in an uploaded file that you place on some public file sharing site (eg: dropbox, onedrive, google drive, etc).

  • dharmendars007's avatar
    dharmendars007
    Memorable Member
    1 year ago

    Hello KBD , 

     

    Have you clicked on this button to expand the table after merging the tables ? Please try the same..

     

     

    If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

     

    Thank You

    Dharmendar S

    LinkedIN