Checking on a column, concatenate values of two other columns

Hello @soumyabg,

As per my understanding, a “simple” Column Expressions” will do :
Example : From start to result :

For your dataset the formula should look like this :
if (column(“option_present”)==“False”) {
join(column(“question”),column(“answer”))
} else {column(“question”)}


Ps: You have to check “Replace Column” in the node

Basic Javascript : JavaScript | MDN (mozilla.org)

Br,
Samir

4 Likes