Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cheburashka
Creator III
Creator III

How to convert the value '1' into the format '000001' ?

Hello,

I want to create a new field "A" with the values '2012000001, 2012000002,...,  2012000011,'.

These values are created from the values of the fields "number" = '1,2,3,4,...' and "year" = 2012,2013,2014.

How do I create the field A in the script?

How to convert the value '1' to '000001' ?

, Thanks for your input, Koen

1 Solution

Accepted Solutions
swuehl
MVP
MVP

=num(1,'000000')

or in your script

LOAD

     year,

     number,

     num#(year & num(number, '000000')) as A,

     ...

View solution in original post

2 Replies
swuehl
MVP
MVP

=num(1,'000000')

or in your script

LOAD

     year,

     number,

     num#(year & num(number, '000000')) as A,

     ...

MayilVahanan

Hi

Try like this

=Num(1,'000000')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.