Pivot tables basis data

#1

Hello team,

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

Regards
Vaibhav

#2

Hi Vaibhav,

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

#3

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

Greetings

#4

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

#5

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

image
and make it this way
image

#6

Easy peasy.

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

image
image.png1073×501 22.2 KB

PS. That’s actually unpivoting.

#7

Thanks, this resolves!

#8

Moved to #uncategorized

#9

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)

#10

OK, we will add it in v4.2.