Regular expressions allow for matching several columns at once. We would like to have an easy way of ordering columns via RegEx, so that column order is not dependent on simple order operations like "ascending","decending" and also multiple columns with similar pattern could be included/excluded at a certain position.
ADMIN RESPONSE
Mar 14, 2022
Thank you for your great idea. While we cannot commit to a specific target version, we will consider adding it to our future internal backlog. If you can add further information about the context of this feature, please add it here so we can evaluate it more fully.
Hi Pierre, thanks for your idea. Can you explain how a RegEx should be used to define a custom order? Also we would need some more information on the use case / which problem this would solve.
That makes it clearer, thanks.
Hello Oliver,
I pasted the xml definition : https://justpaste.it/2brqd
in the FT_extraColumns I would like the following order:
Country | Version | <denormalized periods> | Product | extraColumn1
I cannot add the fields in the Target section since the number of periods can be variable
The 2 possibilities are to consider the order of the fields in the regex:
Country|Version|[0-9]{4}\-[0-9]{2}|Product|extraColumn1
or a possibility to reorder the columns dynamically (maybe a new component ?)
hope this is clearer ?
Best
Hi Pierre, thanks for your idea. Can you explain how a RegEx should be used to define a custom order? Also we would need some more information on the use case / which problem this would solve.