Always load 6 digits?

qlikuser222 — Sat, 16 Nov 2024 01:21:05 GMT

Hi Everyone,

I have a question on how to load a filed with alwys 6 digits?

For example below Source filed has number like

Source Field

123456

12345

123

1234

But in I want to load them as 6 digits adding 0 in the front like below

SourceFiled:

Load

123456

012345

000123

001234

Please help me understand the way to do it

Thanks

Re: Always load 6 digits?

TimvB — Tue, 04 Feb 2020 21:39:06 GMT

In the script use the following:

NUM(YourField,'000000') as LeadingZeroField

Hope it helps!