How do I add a value to the beginning of a column for every field?

[TrifactaUsers]

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

[TrifactaUsers]

And ... Yay.

set col: SLG,CumGifts value: MERGE(['$',$col])

[Trifacta_Alumni · Accepted solution]

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

[Trifacta_Alumni]

...invalid for the data type.

Cheers,

-SteveO