Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Duplicate Values when Merging - Dynamic Index needed to filter out duplicates

Hello!  I'm having an issue where several rows of my data are duplicating causing many different measures ($, Price, etc) to be overstated.   I'm merging two tables by a singular column (UPC) - I ...
Need Help
Show and Tell
Tips and Tricks
Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Anonymous 

 

You can Merge Queries on Multiple Columns, you just need to select them in the right order

 

Best Regards,
Mariusz

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hey Mariusz  thanks for the follow up. Unfortunately one of the tables I'm merging only has 3 columns. (As I'm only adding essential segmentation to another table). So one of the tables only contains 1 like column (UPC).

    • Mariusz's avatar
      Mariusz
      Community Champion
      6 years ago

      Hi Anonymous 

       

      You can use Group By 

       

       

      Best Regards,
      Mariusz

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

       

    • v-juanli-msft's avatar
      v-juanli-msft
      Community Support
      6 years ago

      Hi Anonymous 

      Could you show some example so we can make a test?

      It is appreciated to upload some screenshots or paste some data.

       

      Best Regards
      Maggie
      Community Support Team _ Maggie Li
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.