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.
Anonymous's avatar
Anonymous
Not applicable
6 years ago

A really ugly way to get what I need would be to just to pull the product codes in a distinct list (and only the product codes) and then lookup to each of the original product tables in turn in a calculated column (if blank lookup to the next table) to return the product name etc, but I've got 200,000+ products and it seems excessive..  Which simpler way am I missing?