Log In
Register
Home
July 17, 2018
Offline
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
June 28, 2016
Offline
do you have an example of what each table contains and what the merges would be ?
July 17, 2018
Offline
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)
