Forum Discussion
How to Marge Multiple Table into One Table Without data duplication
Hi, When I Merge or append to combine all tables into one table, then data duplicate one-row repeat Multiple time. let Source = Table.NestedJoin(Location_Details, {"Location_Id"}...
Hi Anonymous
If i merge these two tables
quantity
| location id | data1 | data2 |
| 1 | a | 1 |
| 1 | b | 2 |
| 2 | c | 3 |
| 3 | d | 4 |
| 4 | e | 5 |
| 4 | f | 6 |
profit
| location id | data3 | data4 |
| 1 | a | 1 |
| 1 | b | 2 |
| 1 | c | 3 |
| 2 | d | 4 |
| 2 | e | 5 |
| 3 | f | 6 |
| 3 | a | 7 |
| 3 | b | 8 |
| 4 | c | 9 |
As there are duplication in "location id' in each table, so it can't detemine which id they match each other.
Best Regards
Maggie
Thanks, v-juanli-msft FOr Reply.
IF I want to Combine all table so how can I merge. Any Solution?