Forum Discussion

2 Replies

  • dfs29 , for that a set of columns should create key.

    You can select more than one column join column in case of the merge. (Power Query) . Use shift to select more than one column

     

     

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support

    Hi, dfs29 

    It is recommended to add an index column to each table, and create relationship between the two tables/merge table based on index column.

     

    Best Regards,
    Community Support Team _ Eason