How to select more than one column via json

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?

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

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