Forum Discussion
Solved
To Keep Duplicate Row but Delete Value from One
Dear All, I have used merge Leftouter base one Col1 , Col2, Col3, I have duplicates in this concatenation Col1-Col2-Col3, I want to keep the duplicate row but value in only one row resulted from...
Hi biengineer ,
if you use " try [Merged]{0} otherwise null " it should work.try this function
= Table.FuzzyNestedJoin(Table1,{Col1 , Col2, Col3},Table2,{Col1 , Col2, Col3},"n",JoinKind.LeftOuter,[Threshold=1,NumberOfMatches=1])
try this function
= Table.FuzzyNestedJoin(Table1,{Col1 , Col2, Col3},Table2,{Col1 , Col2, Col3},"n",JoinKind.LeftOuter,[Threshold=1,NumberOfMatches=1])
Sir, I got error with data that it supports only text column, I converted date to text in both tables. And It has worked great with leftouter.
Thanks for that.
I want to do it with fullouter, and import all the rows from the Table 2 while keeping all rows of Table 1. After this step wish to apply this step
=Table.FromRecords(List.TransformMany(Table.ToRecords(#"Merged Packing"),each Table.ToRecords([Packing]),(x,y)=>Record.RemoveFields(x,{"Packing"})&y))
