Get Free Trial

Ability to transform (reduce) text data before aggregation?

Michael T asked on December 31, 2020

If we have a set of data
headers: location, data
“A–1”, 1
“A–1”, 1
“A–2”, 1
“B–1”, 1
“B–2”, 1
Where “A–1” is a simple text field that represents building A and room 1 (– is a delimeter)
is there a way in flexmonster to process the data so it groups it based on building? (i.e. transform the text in location column with some function (e.g. substring before the –) before doing the aggregations?
e.g. the above would aggregate to
A, 3
B, 2

1 answer

Illia Yatsyshyn Illia Yatsyshyn Flexmonster January 4, 2021

Hello, Michael,
Thank you for your question.
We want to explain that the data can not be transformed after it is loaded to the component. Flexmonster will treat “A–1” and “A–2” as different members.
We suggest preprocessing the dataset in the way the building and room are different fields, for example:

Building, Room, Value
A, 1, 1
A, 1, 1
A, 2, 1
B, 1, 1
B, 2, 1

This transformation would allow achieving the desired aggregation results.
Please let us know if it works for you.
Feel free to contact us in case other questions arise.
Kind regards,

Please login or Register to Submit Answer