Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Merge tables

Hi, I'm trying to merge two tables ,assuming Table has duplicate records and I'm deleting the duplicates before merging based on a certain criteria (date descending) ,ie delete record with the older...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    8 years ago

    Hi Anonymous,

    Based on my test, I suggest you to add an index column to merge tables.

    After you hvae remove the duplicate rows, you could add the index column and merge the two tables like the picture below:

    Result:

     

    Regards,

    Daniel He

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous

 

Can you help with sample data ?

 

Thanks
Raj