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.