Hello Alteryx Team,
Needing assistance on the attached dummy input file. If the first column is D3, then the 2nd column should consist of 9 digits. If incase it only consist of less than 9 digits, then add zeroes in the beginning to make it 9:
In the example above, you can see that there are 3 values that does not contain 9 digits. The output should be like this (all 9 digits) under D3:
Thank you in advance.
Solved! Go to Solution.
Hi @PassION_es
If you have leading zeros you'll have to change the field type to a string, then you can simply add the formula..
PadLeft([TIN (9 Digits)], 9, "0")
Hopefully that helps,
Mark
Hey @PassION_es
You can do this using the padleft formula:
PadLeft([TIN], 9, '0')
Attaching workflow for reference!
Use the formula tool and write
PadLeft([TIN (9 digits)], 9, "0")
Hope this helps. Please mark as solved if is solved the issue.
Hi @PassION_es
You can achieve it by using the below formula
PadLeft([TIN (9 Digits)], 9, "0")
Many thanks
Shanker V
hello All,
I applied your formula, incorporated it in the conditions but I'm getting the result below:
I think there's something wrong with my conditions.
Can you check on this please? Thanks
@PassION_es you need to adjust your formula like below
IIF([TYPE] = 'D3', PadLeft([TIN (9 Digits)], 9, '0'), [TIN (9 Digits)])
Amazing shortcut conditions. Thanks all!