Forum Discussion

Petanek333's avatar
Petanek333
Icon for Helper III rankHelper III
4 years ago
Solved

Unknown duplicate error when refreshing dataset

Hi, I get an error during a refresh. I get data from an Excel file and a message about duplicate value appears, see below. Problem is, there is no duplicate value in column Product ID in Table OKAY...
Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi Petanek333 ,

     

    Go to your OKAY CZ query, select the [Product ID] column and go to

    Home tab > Remove Rows (dropdown) > Remove Blank Rows

    Home tab > Remove Rows (dropdown) > Remove Duplicates

    Try and apply changes.

     

    Let me know how you get on.

     

    Pete

Petanek333's avatar
Petanek333
Icon for Helper III rankHelper III
4 years ago

Thank you guys for the solutions. Those from BA_Pete  and Anonymous worked well together.