What is the syntax for simply adding a "$" to the beginning of a string field?
I have converted several columns to the float data type so that I can run calculations. However, for my final output, I have converted them back to strings so that I can add a "$" to the beginning of them.
What is the code for this?
Thank you,
/steven
Solved! Go to Solution.
And ... Yay.
set col: SLG,CumGifts value: MERGE(['$',$col])
That'll work. Specifically for numeric values, you can use the NUMFORMAT function too:
https://docs.trifacta.com/display/SS/NUMFORMAT+Function
Probably better to use NUMFORMAT. Your step is a String-based transformation and will therefore reformat all values, even if they are invalid for t.
Cheers,
-SteveO
...invalid for the data type.
Cheers,
-SteveO