

July 17, 2018

Hi I have three merge queries being used to identify unique values in two tables the first two which find the uniques in one table each work fine, but when I merge into one table only one of the rows is fill the other is null
Merge1 = Table.NestedJoin(Bowmans,{"Result"},Main,{"Pallet number"},"Main",JoinKind.LeftAnti)
Merge2 = Table.NestedJoin(Main,{"Pallet number"},Bowmans,{"Result"},"Main",JoinKind.LeftAnti)
Diffs = Table.NestedJoin(Merge1,{"Description"},Merge2,{"Item Number"},"Merge2",JoinKind.FullOuter)
in the Diffs query whichever is first gives the result and the second one just null across columns


July 17, 2018

Hi Thanks for replying but I think I fixed it in the third merge query in the screenshot is a column called merge2 I was deleting in in the next step. I discovered that if I expand that column the missing data is there so I merged the matching columns and job done 🙂
Thanks again I am sure I'll have some more questions
John
1 Guest(s)
