Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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?
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?