Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

remove selective duplicate in columns

Need Help

5 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi Anonymous 

     

    Try using Group By instead, select both columns and hit Group By, if you want to keep all other fields you can add them as aggregation like MAX or MIN 

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      why is it using max or min? not kinda sure on how do you do it when u group by the other two columns.

      • Mariusz's avatar
        Mariusz
        Community Champion
        6 years ago

        Hi Anonymous 

         

        If you want to get unique values from "BR" and "Chassis" you will have to do something about the rest of the columns.

        1. Remove them 
        2. Aggregate them ( count, sum, min or max ) 
        3. Include in the group.

        when you use remove duplicates it will use do a similar thing ( take the unique values of selected columns and take first value of every other column not included in the selection ) 

         

        What would be the desired outcome that you are expecting?

        Best Regards,
        Mariusz

        If this post helps, then please consider Accepting it as the solution.

        Please feel free to connect with me.
        Mariusz Repczynski