Forum Discussion

TusharGaurav's avatar
TusharGaurav
Helper III
2 years ago
Solved

Getting error Column in Table contains a duplicate value, during incremental refresh.

Hi Experts,   I am trying to apply incremental refresh in few of the tables having huge volume of data. While refreshing the dataset, I am getting the below error: Column 'Product_Key' in Table '...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    Check your RangeStart and RangeEnd filter. Only one of these parameters can be inclusive, the other must be exclusive

     

    RangeStart <= [partition date] < RangeEnd

lbendlin's avatar
lbendlin
Super User
2 years ago

Check your RangeStart and RangeEnd filter. Only one of these parameters can be inclusive, the other must be exclusive

 

RangeStart <= [partition date] < RangeEnd

  • TusharGaurav's avatar
    TusharGaurav
    Helper III
    2 years ago

    Thanks Ibendlin,

    I was actually RangeStart <= [partition date] <=RangeEnd, which I modified as per your suggestion.

    The dataset refreshed post the changes.

  • Praveen_Rangu's avatar
    Praveen_Rangu
    Frequent Visitor
    2 years ago

    even after doing that, I am getting the same error. Will it happen if that unique ID is present in archived data and got updated in a recent refresh 

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      Praveen_Rangu please open a new thread and provide more details.