topic Add while loading in QlikView

Add while loading

hkg_qlik — Mon, 13 Aug 2012 14:23:21 GMT

Hi,

I have a fieldname Employer_Code with different values such as 1133, 33001, 2211, 33223 ,...

Now I want to add 00 incase the code is four digit like 1133 and 0 if its five digit like 33001.

Regards,

Mon, 13 Aug 2012 14:25:06 GMT

Num(Employer_Code,'00000') AS Employer_Code

Anonymous — Mon, 13 Aug 2012 14:27:21 GMT

Hi,

Answer:

if (left(Employer_Code,4) = '1133',

'00' & Employer_Code,

if (left(Employer_Code,5) = '33001',

'0' & Employer_Code,

Employer_Code

)

) as New_Employer_Code

Kind regards,

Janusz

Mon, 13 Aug 2012 14:33:18 GMT

hi,

i don't know what your specific needs are but you can do something like this

=if(len(Employer_Code)=4,'Employer_Code'&00, if (len(Employer_Code)=5,'Employer_Code'&0) ))as something

if have not tried this but it might help you in the right direction

Regards,

cesaraccardi — Mon, 13 Aug 2012 14:41:00 GMT

Hi,

I think the best solution is the suggested by Felim with a little correction:

Num(Employer_Code,'000000') AS Employer_Code

This will automatically format the number to fill the leading zeros.

Regards,

Cesar

Mon, 13 Aug 2012 14:43:49 GMT

ahh yea I was appending a zero.... stupid me