Forum Discussion

andrearuggeri's avatar
andrearuggeri
Helper I
2 years ago
Solved

Pivot column error

Hi all,

 

I have this dataset imported from Sharepoint and I need to pivot for "Question Caption" column

 

 

but when I do it, with "RealAnswer" as Value and Don't aggregate option, I get this error on the "Attività svolta" new column

 

 translation is "There were too many elements in the enumeration to complete the operation"

 

What's the problem?

 

Thanks in advance!!!

Need Help
  • mussaenda's avatar
    mussaenda
    2 years ago

    yes there are multiple ways to do that.

     

    Option 1 is to add 1 from the "Attività svolta" if there is a duplicate before pivoting.

    Option 2 is to put together the answers in one row for "Attività svolta" if there is any duplicate before pivoting.

     

5 Replies

  • mussaenda's avatar
    mussaenda
    Community Champion
    2 years ago

    Hi andrearuggeri ,

     

    one of the possible reasons is, there is a duplicate value for that person. have you checked if there are any duplicates?

    • andrearuggeri's avatar
      andrearuggeri
      Helper I
      2 years ago

      Hi mussaenda and thank you for your reply.

      For sure there are duplicates, the field "Attività svolta" has few options as answers, so for different visits (CallID column) there may be the same value.

       

      However if you look at the screenshot, the first x lines contain the same "Visual Merchandising" value for that column, the problem occur when the value changes, in the error field there should be a different value.