Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Not Planned
Workspace Jedox Platform
Categories Integrator
Created by Guest
Created on Oct 20, 2021

New Transform: Row Normalization

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.