I have a task where I need to search and replace 3 distinct words (so cannot use wildcards) across 30 string columns. Now, as far as I can see I will need to make 90 String Replacer nodes to undertake this task, there must surely be a simpler way which I am not aware of. I've tried to think of a way to do it with variables and loops but could not think of one. Its not the first time I've wanted to do this task.
It would be useful to be able to select multiple columns in the "string replacer" node rather than being restricted to one column.
Or another useful feature would be to have a looping facility which rather than collates the results at the "Loop End" in terms of row collation or column collation, or just takes the results from the last iteration at the "Loop End", there is a 3rd option which takes the results table after each iteration at the "Loop End" node and sends that table back to the "Loop Start" and so on, until all iterations are completed. This would have been useful in this task by using column names as a variable which could be fed into the string replacer node.