Let us know how we can make Jedox even better!
This transform would work the same as the Field Normalization ,but for rows. Right now, if you try to normalize rows with the field transform, the delimited values are put into a single column.
This new transform would take a single column input, specify a delimiter and split that column into n columns. The columns would be variable based on the original string.
The transform would have the same options as the Field Normalization, plus and additional:
Rows to delimit
Base the delimited columns on n rows
Base the delimited columns on all rows in source
there would be a warning if the user selected the second option as the transform could be very slow if the source is huge.