Forum Discussion

biengineer's avatar
biengineer
Helper I
3 years ago
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...
Need Help
Show and Tell
Tips and Tricks
  • ImkeF's avatar
    ImkeF
    3 years ago

    Hi biengineer ,
    if you use " try [Merged]{0} otherwise null " it should work.

     

  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    try this function

     

    = Table.FuzzyNestedJoin(Table1,{Col1 , Col2, Col3},Table2,{Col1 , Col2, Col3},"n",JoinKind.LeftOuter,[Threshold=1,NumberOfMatches=1])

biengineer's avatar
biengineer
Helper I
3 years ago

Sir, I thought it worked, but still shows the duplicate value. 

 

= Table.AddColumn(#"Merged Packing", "Custom", each try [Packing]{0} otherwise null)

 

 

= Table.ExpandRecordColumn(#"Added Custom7", "Custom", {"PackingQty"}, {"PackingQty"})

 

Should have shown only 1229.

 

Best Regards.

 

 

ImkeF's avatar
ImkeF
Community Champion
3 years ago

Hi biengineer ,

then my understanding of your requirement was wrong.
It might be that you need a right outer join instead, but still not sure about your exact requirements.
Also check out wdx223_Daniel s solution. It does the job with just one join command.