Dear visitor, despite all the challenges, our team continues operating at full speed.

We are ready to help with any questions you may have. Please fill out this quick form and we'll get back to you.

Fill the form
Get Free Trial

Pivot non numeric value

Riyan asked on April 11, 2018

Some of value on our CSV is sometime contain non numeric value i.e. “n/a”.
is it possible to pivot the value on the flexmonster?
for example,
the csv datasource is :
and result shall be :


1 answer

Tanya Gryshko Flexmonster April 11, 2018

Hello, Riyan,
Thank you for posting to our Support Forum!
Non-numeric values are treated as null values and hidden intentionally. The reason for this is to avoid displaying too much empty rows when the data contains lots of such values.
For cases when null values are displayed, you can configure null values to be shown as n.a. Please refer to this sample and see how this can be done: n.a for null values is set via number formatting at line 43.
Please let me know in case of other questions.

Please login or Register to Submit Answer