Solved! Go to Solution.
This can be done in two steps (well, technically one, but I'll break it up into two for clarity). The first thing you'll want to do is merge 11 0s to your column.
You can do this with the following step:
Transformation: set
Columns: your_column
Formula: Merge(['00000000000', your_column])
This will give you a column with values ranging in length from 11 characters (in the case of an empty row) to 11 + your longest string of numbers.
Then, you'll want to use the RIGHT() function to trim to the right most 11 digits. This step will look like this:
Transformation: set
Columns: your_column
Formula: RIGHT(your_column, 11)
which will have this effect:
Hope this helps :)
Nice! I was able to do this in one step by putting the MERGE inside the right function, so it looked like RIGHT(MERGE(['00000000000', order_number]), 11) 😀