Hi,
MODIFY COLUMN NAMES transformation is really time saving.
Could we have the option : "all lowercase" and "all uppercase"
Regards
CVO
Try using "unpivot" where the columns become "labels" and then use "Modify Column" and "UPPERCASE" and then "Pivot".
Another way is to derive the table and "Unpivot" and leave only the labels (which will be the column names). Create a new column with "UPPERCASE" and in the normal column table, use the "Rename With LookValue" action and search for the new name.
Does the pivot action work like that? If I try to unpivot I would get two columns; labels and data. From there you can all uppercase the labels. But when you try to pivot back, if you don't have an aggregate, you are likely to get a non-unique group error. I just tried it on a table I use regularly and got the below
Error: Value in row 2 is not unique in its group. Use aggregation when values in groups are not unique.
Source: action "Pivot", table "DE_SALES_SOLUTIONS.FORECAST"
If you do use an aggregate, the form of the table no longer seems to be the same because it is going to aggregate, and you will get sum,average etc on whatever you pick. Essentially one line instead of just the original column labels transformed with the original records in tact before the pivot.
Is there a configuration I am missing to make this work? Because I am looking to do something similar.
