Merge queries generating duplication of lines

[CR]

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

[vanessafvg]

@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.

[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]

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]

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

[vanessafvg · Accepted 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?

[CR]

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

[vanessafvg]

@CR  well done.