Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=num(1,'000000')
or in your script
LOAD
year,
number,
num#(year & num(number, '000000')) as A,
...
=num(1,'000000')
or in your script
LOAD
year,
number,
num#(year & num(number, '000000')) as A,
...
Hi
Try like this
=Num(1,'000000')