Forum Discussion

lawada4's avatar
lawada4
Frequent Visitor
3 years ago

merge in power query is returning null

im trying to merge 2 tables in power query using a joining key. the joining key is a column that i created byconcatenating several coloums in each table. the coloumns that  i concatenated are the same in both the tables and im using this joining key to merge the 2 tables.  after i mergerd no rows are getting matched and all columns are null. any idea on how to fix the merge?

 

Need Help
Show and Tell

1 Reply

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi lawada4 

    That means the values in the joining key columns in both tables are different. Can you share the two tables, ideally in a pbix?  or a sample of the tables that allows to reproduce the problem  

     

    		 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.