Custom Formula Question

Hi, How would I make the below formula in a separate column that would add certain columns together with a " - " in between each column value?

$Accounting Month$ + " - " + $SITE ID$ + " - " + $Amount in local currency$

If I understand you correctly, you basically just want to append fields together in a single new field, right? In that case, you could use the above expression within a join() function in the String Manipulation node.

1 Like

Thank you! However, I would like a “-” character between each value. How would I account for this?

Nevermind I used the join function and was able to add in the dashes as well. Thank you for the response! It worked!

1 Like

Hi there @austinbauer,

you can also use Column Combiner where you can specify delimiter :wink:


1 Like

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