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])

ImkeF's avatar
ImkeF
Community Champion
3 years ago

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

 

  • 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.