How to fold

Solved!
emate
Neuron
Neuron
How to fold

Hi All,

Is there a way to fold the data as In attached example?

When I'm using "fold multiple columns" It doesnt work beacuse first I'm folding it by units - it is giving me correct result, but when I'm adding  as a next step fold by sales it is multiplying my rows again. And the idea is to fold the data by units in sales at the same time to end up with each unique row (COL1 to COL6) * numbers of dates (column) to the left.

Thanks,
M

1 Solution
duphan
Dataiker
Dataiker

and the final 2 steps ...

View solution in original post

3 Replies
duphan
Dataiker
Dataiker

Hello 

You will need to use the "Fold multiple columns with pattern".

I attach the steps to follow, note that my column's names are not exactly the same as your, so in your case the pattern for the first step will be UNITS\s(.*)

duphan
Dataiker
Dataiker

and the final 2 steps ...

View solution in original post

emate
Neuron
Neuron
Author

Thanks for your help!

0 Kudos
A banner prompting to get Dataiku DSS
Public