Forum Discussion

TBenders's avatar
TBenders
Icon for Helper II rankHelper II
10 years ago
Solved

Combining rows based on unique id, and combining information

Hi,   This is my first post on this forum, but I've been 'lurking' around for a while, learning as I go. Hopefully one of you BI-wizards can help me out with my particular case for which I couldn't...
Need Help
  • ImkeF's avatar
    ImkeF
    10 years ago

    Sorry, forgot to mention that you need to turn the aggregation off: last step: Advanced Opions: Don't aggregate bofore hitting the last OK.

Shrutisakpal's avatar
Shrutisakpal
New Member
6 years ago

Hi Imke,

 

I tried your solution for one of my data which i need in same format.

 

1) Check column ID -> Mouse rightclick -> Unpivot Other Columns: This will delete the nulls

2) Check column Attribute -> Transform -> Any Column -> Pivot Column: Choose "Value" in Values Column

 

But its giving error "There were too many elements in the enumeration to complete the operation.". Can you please help?

 

Regards,

Shruti