Pivot tables basis data

vaibhavtandon87 · December 7, 2019, 3:10pm

Hello team,

Is there plan in future release to have a feature to create pivot tables?

Regards
Vaibhav

dgudkov · December 7, 2019, 4:41pm

Hi Vaibhav,

Tables can be pivoted using the “Pivot” action. Do you have something else in mind?

cvo · December 7, 2019, 7:39pm

If we could specify several rows for the header, it would be great.

Greetings

dgudkov · December 7, 2019, 7:52pm

Just for viewing/analyzing or as a data source for further calculations?

cvo · December 7, 2019, 8:10pm

as a data source.
To extract the stack of excel spreadsheets sent by controlers that look this way

and make it this way

dgudkov · December 7, 2019, 8:40pm

Easy peasy.

multirow-unpivot.morph (3.1 KB)
Book1.xlsx (8.8 KB)

PS. That’s actually unpivoting.

vaibhavtandon87 · December 8, 2019, 5:25am

Thanks, this resolves!

dgudkov · December 8, 2019, 8:47am

Moved to #uncategorized

cvo · December 8, 2019, 1:02pm

Unfortunately we can’t specify a separator in the ‘Label columns’ transformation.
As Excel is far from being foolproof, if a have some space in the header values then the transformation look this way (you can surely make it simpler)
Could you add a separator select in the ‘Label columns’ transformation ?
Please Dmitry.

Regards

multirow-unpivot2.morph (7.8 KB) Book1.xlsx (9.8 KB)

dgudkov · December 8, 2019, 7:28pm

OK, we will add it in v4.2.