About EasyMorph Tutorials & Examples Web-help

Pivot tables basis data

Hello team,

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

Regards
Vaibhav

Hi Vaibhav,

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

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

Greetings

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

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

Easy peasy.

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

PS. That’s actually unpivoting.

Thanks, this resolves!

Moved to #uncategorized

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)

OK, we will add it in v4.2.

To learn more about EasyMorph visit easymorph.com.