we have 3 multiple sheets, then how to do pivot in Dataiku?
Options
Piyush12
Registered Posts: 2 ✭
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?
Answers

Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,744 NeuronOptions
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?