Need to count Zeros as per number in alteryx

[PoliteGolite301991]

Hi Team,

Need help one below.

Please suggest.

I have a field with numbers and I need to concatenate number of zeros based on the number in that field.

Example:

Inputs:

Number	Decimals
2	1
2	1
3	1
3	1
3	1

Output:

Number	Decimal
2	100 (If 2 then 2 zeros to be appended)
2	100
3	1000
3	1000
3	1000

[FrederikE]

Hey @PoliteGolite301991,

 

toString(Decimals)+Right("000000000000000000", [Number])

This formula should work.

[OllieClarke]

Hi @PoliteGolite301991  a more scalable solution would be to use 

PadRight(tostring([decimals]),length([decimals])+[number], “0”)

[OllieClarke]

Apologies, edited after fat thumbing it