Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hello,
We have 3 multiple sheets and each sheet has more than 50 columns, and I want the results in pivot table/PO format.
How to do? Should I use Pivot Recipe or Data Preparation recipe?
Can anyone will help me?
Import each sheet into a separate dataset, then use the stack to "stack" the data together (assuming that's what you mean by 3 multiple sheets), then use the Pivot recipe to pivot the data.
Thanks, If we stack all 3 datasets and then I am using the UNION option, we will get 240 columns in total. so what to do?
In Pivot, there are 2 options, Create Column and With Row Identifier.
I only need the data row identifier. Then what to do with the column?