Find and replace in Column names?

I have merged 4 datasets side by side so the data is joined by rows.
Now I want to replace (right)(right) with a name indicating which dataset it came from.
In other words I want to do a search and replace as follows:
(right) becomes A
(right)(right) becomes B
(right)(right)(right) becomes C
and so on
Is anyone aware of a find and replace in column names?
Many thanks,
Mark

Answering my own query again!
The answer is simple - in the second tab of the Joiner node called “Column Selection” there is an Append custom suffix option.
Problem solved!

4 Likes

Thanks for posting your solution!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.