Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I'm surprised to discover that some lines in one of my dashboard are duplicated when I merge 2 tables through the Query Editor. I know the differences between the types of links as explained on the site RADACAD (but maybe not finally).
But, first of all, I don't understand why it didn't happened few days/weeks ago with the same data !
Somebody faced to this issue ?
Regards,
CR
Solved! Go to Solution.
@CR still hard to see without the source data, ie the tables before they merge
you sure you dont have duplicates? or any funny characters, have you done a trim and clean on those columns before you do a merge?
Proud to be a Super User!
@CR can you share what you have done, very hard to figure it out with such little information
has the data changed at all or is it exactly the same, please give more information in order to assist, or share the file.
Proud to be a Super User!
Hi @vanessafvg
You're right, please find below some details.
Table 1
DOC REFERENCE | OBJECT | CODE DOCREF1 | START | 1 DOCREF1 | IFD | 1
Table 2
CODE | DISCIPLINE 1 | DISCI_1 2 | DISCI_2
In Table 1, I've added 2 steps;
Merge query 1
= Table.NestedJoin(#"previsous step",{"CODE"},TABLE1,{"CODE"},"TABLE_2",JoinKind.LeftOuter)
Merge query 2
= Table.ExpandTableColumn(#"Merge query 1", "TABLE_2", {"CODE"}, {"CODE"})
The Merge query 1 is fine for me (no duplication and matching between the tables)
but not the Merge query 2 that duplicates the lines in the Table 1.
DOC REFERENCE | OBJECT | CODE | DISCIPLINE DOCREF1 | START | 1 | DISCI_1 DOCREF1 | START | 1 | DISCI_1 DOCREF1 | IFD | 1 | DISCI_1 DOCREF1 | IFD | 1 | DISCI_1
Regards,
CR
Hi @vanessafvg
You're right, please find below some details.
Table 1
DOC REFERENCE | OBJECT | CODE DOCREF1 | START | 1 DOCREF1 | IFD | 1
Table 2
CODE | DISCIPLINE 1 | DISCI_1 2 | DISCI_2
In Table 1, I've added 2 steps;
Merge query 1
= Table.NestedJoin(#"previsous step",{"CODE"},TABLE1,{"CODE"},"TABLE_2",JoinKind.LeftOuter)
Merge query 2
= Table.ExpandTableColumn(#"Merge query 1", "TABLE_2", {"CODE"}, {"CODE"})
The Merge query 1 is fine for me (no duplication and matching between the tables)
but not the Merge query 2 that duplicates the lines in the Table 1.
DOC REFERENCE | OBJECT | CODE | DISCIPLINE DOCREF1 | START | 1 | DISCI_1 DOCREF1 | START | 1 | DISCI_1 DOCREF1 | IFD | 1 | DISCI_1 DOCREF1 | IFD | 1 | DISCI_1
Regards,
CR
Hi @vanessafvg
You're right, please find below some details.
Table 1
DOC REFERENCE | OBJECT | CODE DOCREF1 | START | 1 DOCREF1 | IFD | 1
Table 2
CODE | DISCIPLINE 1 | DISCI_1 2 | DISCI_2
In Table 1, I've added 2 steps;
Merge query 1
= Table.NestedJoin(#"previsous step",{"CODE"},TABLE1,{"CODE"},"TABLE_2",JoinKind.LeftOuter)
Merge query 2
= Table.ExpandTableColumn(#"Merge query 1", "TABLE_2", {"CODE"}, {"CODE"})
The Merge query 1 is fine for me (no duplication and matching between the tables)
but not the Merge query 2 that duplicates the lines in the Table 1.
DOC REFERENCE | OBJECT | CODE | DISCIPLINE DOCREF1 | START | 1 | DISCI_1 DOCREF1 | START | 1 | DISCI_1 DOCREF1 | IFD | 1 | DISCI_1 DOCREF1 | IFD | 1 | DISCI_1
Regards,
CR
@CR still hard to see without the source data, ie the tables before they merge
you sure you dont have duplicates? or any funny characters, have you done a trim and clean on those columns before you do a merge?
Proud to be a Super User!
After 3 hours I found out! Special characters! It was a C cyrillic (not latin)... impossible to see with an eye...
Thanks for the suggestion because it helped me!
Regards,
CR
@CR well done.
Proud to be a Super User!