Adding zero to make it 9 digits

Question

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.

make it 9 digits.xlsx

DenisZ · Accepted Answer

Use the formula tool and write

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

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

PassION_es · Accepted Answer

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 Answer

Hi @PassION_es

Please see the below.

Input:

Output:

gautiergodard · Accepted Answer

Hey @PassION_es

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

binu_acs · Accepted Answer

@PassION_es  you need to adjust your formula like below

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