Forum Discussion

CR's avatar
CR
Resolver II
8 years ago
Solved

remove duplicate - specific values

Hi!   I need help! I get a list of references. Each reference (column 1) has several revisions (column 2) so I get several lines for one reference: line 1 => ref_1 | rev A line 2 => ref_1 | rev ...
Need Help
  • CR's avatar
    CR
    8 years ago

    Dear Smoupre,

     

    Thanks a lot, I used the buffering and it worked !

     

    Before:

     

    let
    ...
    #"Inserted Merged Column" = Table.AddColumn(#"Added Conditional Column", "DOC_REF", each Text.Combine({[Document Client Reference], Text.From([#"REV-NEW"], "fr-FR")}, "_"), type text),
    #"Sorted Rows" = Table.Sort(#"Inserted Merged Column",{{"DOC_REF", Order.Descending}}),
in
    ...

    Now:

    let
...
    #"Inserted Merged Column" = Table.AddColumn(#"Added Conditional Column", "DOC_REF", each Text.Combine({[Document Client Reference], Text.From([#"REV-NEW"], "fr-FR")}, "_"), type text),
    #"Sorted Rows" = Table.Sort(#"Inserted Merged Column",{{"DOC_REF", Order.Descending}}),
    #"Buffered" = Table.Buffer(#"Sorted Rows"),
    #"Removed Duplicates" = Table.Distinct(#"Buffered", {"Document Reference"})
in
    #"Removed Duplicates"

    Thanks !

     

    Regards,

    CR

  • CR's avatar
    CR
    Resolver II
    8 years ago

    Dear Smoupre,

     

    Thanks a lot, I used the buffering and it worked !

     

    Before:

     

    let
    ...
    #"Inserted Merged Column" = Table.AddColumn(#"Added Conditional Column", "DOC_REF", each Text.Combine({[Document Client Reference], Text.From([#"REV-NEW"], "fr-FR")}, "_"), type text),
    #"Sorted Rows" = Table.Sort(#"Inserted Merged Column",{{"DOC_REF", Order.Descending}}),
in
    ...

    Now:

    let
...
    #"Inserted Merged Column" = Table.AddColumn(#"Added Conditional Column", "DOC_REF", each Text.Combine({[Document Client Reference], Text.From([#"REV-NEW"], "fr-FR")}, "_"), type text),
    #"Sorted Rows" = Table.Sort(#"Inserted Merged Column",{{"DOC_REF", Order.Descending}}),
    #"Buffered" = Table.Buffer(#"Sorted Rows"),
    #"Removed Duplicates" = Table.Distinct(#"Buffered", {"Document Reference"})
in
    #"Removed Duplicates"

    Thanks !

     

    Regards,

    CR