Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Shipped
Workspace Jedox Platform
Categories Other
Created by Guest
Created on Jul 2, 2019

Automatic (De)-normalization Fields

wenn you have several columns to denormalize or normalize you have to put them manually in the fields. This is now easier since you can grab the input columns but this is not dynamic. This would be awesome if instead of entering the name of the field to normalize or denormalize you could enter a regex. Let's take an example to illustrate that. Let's say that you have the following input: Country | Year | Datatype | Month1 | Month2 | Month3 I use a TableNormalization to turn the columns Month1, Month2, Month3 into rows. Now let's say that my input changes, and I have 2 more columns: Country | Year | Datatype | Month1 | Month2 | Month3 | Month4 | Month5 I have to change all the TableNormalization to reflect the change, and add 2 more rows. If I were able to enter: ^Month.* in a single row then it would normalize automatically all the columns that comply with the regex
  • Guest
    Reply
    |
    Oct 28, 2021

    shipped, isn't it ?