I need to prefix '0' onto all the values in a column.
Example: 2, 3, 6 should become 02, 03, 06
Solved! Go to Solution.
While there are a few ways to accomplish this, the easiest, in my opinion, is to Apply a formula [set] to your column (see here: https://docs.trifacta.com/display/PE/Set+Transform) using the MERGE( ) function (see here: https://docs.trifacta.com/display/PE/MERGE+Function).
This would follow the form:
Transformation: set
Columns: your_column
Formula: MERGE(['0', your_column])
In your case, the recipe step would be:
set col: your_column_name value: merge(['0',$col])