Forum Discussion
Merge Tables duplicate rows
I have two tables, first "EC", second "NE".
In the table "EC" i have the ref "Five" one time, but in table "NE" i have the same ref in two rows.
When i merge two tables with a key that i have created "chaveec" (key+ref) the merge table duplicates my rows.
The wrong result is that:
But i want this:
Can you help me please?
Hi , ruinaldo
As mentioned by parry2k ,both of the merged tables have two pieces of data with a "chavee" of 5, Powerbi cannot determine which record in Table 1 matches with which record in Table 2, so 2 * 2 records are generated.
It is suggested to create custome column "chaveec" (key+ref +number) as a key to merge rows.
Here is a demo . Please refer to the query "merge2"
Best Regards,
Community Support Team _ Eason
2 Replies
Hi , ruinaldo
As mentioned by parry2k ,both of the merged tables have two pieces of data with a "chavee" of 5, Powerbi cannot determine which record in Table 1 matches with which record in Table 2, so 2 * 2 records are generated.
It is suggested to create custome column "chaveec" (key+ref +number) as a key to merge rows.
Here is a demo . Please refer to the query "merge2"
Best Regards,
Community Support Team _ Eason
