Custom Formula Question

austinbauer · April 13, 2020, 6:08pm

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$

ScottF · April 13, 2020, 6:21pm

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.

austinbauer · April 13, 2020, 6:22pm

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

austinbauer · April 13, 2020, 6:25pm

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

ipazin · April 15, 2020, 3:05pm

Hi there @austinbauer,

you can also use Column Combiner where you can specify delimiter

Br,
Ivan

system · October 15, 2020, 3:05am

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