It would be nice to have the replace function additionally - as it is now only for the headers.
The Rename Cols transform has a replace function:
But it is a one-time change. Do you mean something that renames columns dynamically (based on the input header every time the header passes through the transform)?
yes exactly - that would be awesome
It is somewhere in the wishlist. It will require some careful thought on the best way to do it.
1 Like
I think there is a solution to do this with just 3 transformations (including Replace) or for big data sets with 5 transformations.
The simple one is on top in the green framed part.
In case of big data sets transpose might be cost intensive or limited, then the blue framed part should work. Assumption for that one is that the key column is filled in any case and do not include empty values. If this is not the case the filter must be adapted to get only the header as result. Stack is based on column numbers. The second transpose in both ways must have the “has header” field marked.
Header Replace.transform (4.7 KB)
1 Like
thanks olaf 
i look into the solution - for me - i try out the second options for big data sets
let me know if it solves your issue