How to select more than one column via json

Questions
1

Hello! I’m trying to select more than I column to target in data transformation. As in the node I can just put one (comma separated don’t work), I was trying to use {{json.columnB, json.columnB}} but is also don’t work. This way I have to create a separed data transformation node for every column I need to change.

There’s a way to do it just with one node?

2

Hi @Igor_do_palido_ponto

The expressions are basically Javascript, so you are not really selecting a column value when you add an expression.
If you want to concatenate them you can use a “+” sign to add one o the other.

2 Likes