Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Natural Left join not capturing all the data

Hello,   I have two tables with a one in one relation. Table 1: UID 01.A 01.B 02 03 04 05 06 07 08 09 10 11 12 13 14 217 350 430 56 601...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi Anonymous ,

    According to your description, I create a sample, and merge queries use Left Outer join kind(Table2, Table1).

    After expand table, as 002 is the only one in Table2 but not in Table1, it goes to the last line by rules. I doubt if it got to the last line you didn't find it.

    I attach my sample below, please go to Power Query applied steps to check.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi Anonymous ,

According to your description, I create a sample, and merge queries use Left Outer join kind(Table2, Table1).

After expand table, as 002 is the only one in Table2 but not in Table1, it goes to the last line by rules. I doubt if it got to the last line you didn't find it.

I attach my sample below, please go to Power Query applied steps to check.

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.