Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to Remove Duplicates in Calculated Table?

Hi All   I'm trying to remove duplicate product codes from a calculated table without success.    I've loaded in three separate lists of product codes and products names (plus department etc) fro...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    When i append two tables in Query editor, tehn remove duplicates rows for the "Product code" column, it returns distinct  "Product code", "description" and "department".

    Would you like this result?
    If not, please let me know.
     
    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.
v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Anonymous 

When i append two tables in Query editor, tehn remove duplicates rows for the "Product code" column, it returns distinct  "Product code", "description" and "department".

Would you like this result?
If not, please let me know.
 
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.
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks Maggie!  I don't know why I'd not considered appending the actual queries!  Works perfectly :)