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])
Hi biengineer ,
don't expand the column from the merge (imaging it is called "Merged"). Instead add a column that references that column and picks the first row from it: [Merged]{0}. Now expand this new column.
That will make sure that only the first row of the found matches will be returned and you will keep your original number of rows.