Adding zero to make it 9 digits

[PassION_es]

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.

[markcurry]

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

[gautiergodard]

Hey @PassION_es 

You can do this using the padleft formula:

PadLeft([TIN], 9, '0')

Attaching workflow for reference! 

[DenisZ · Accepted solution]

Use the formula tool and write 

PadLeft([TIN (9 digits)], 9, "0")

Hope this helps. Please mark as solved if is solved the issue.

[ShankerV]

Hi @PassION_es 

You can achieve it by using the below formula

PadLeft([TIN (9 Digits)], 9, "0")

Many thanks

Shanker V

[PassION_es · Accepted solution]

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

[ShankerV · Accepted solution]

Hi @PassION_es 

Please see the below.

Input: 

Output:

[gautiergodard · Accepted solution]

Hey @PassION_es 

Remove the below portion of your formula and you should get the expected result:

[binuacs · Accepted solution]

@PassION_es  you need to adjust your formula like below

IIF([TYPE] = 'D3', PadLeft([TIN (9 Digits)], 9, '0'), [TIN (9 Digits)])

[PassION_es]

Amazing shortcut conditions. Thanks all!