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
Hi there, yes, you can achieve this by adding a source for dynamic denormalisation. Here is the example.
what is the fix for this? It would be great to have this feature, because currently for every planning cycle we have to manually update the months in the Table Normalization Transform and that's a lot of maintenance.
shipped, isn't it ?