Forum Discussion

Petanek333's avatar
Petanek333
Helper 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

BA_Pete's avatar
BA_Pete
Super User
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