topic Re: Logic Help in QlikView

Logic Help

abhaysingh — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

I have one scenario in which i need to do below transformation

i have customer data like below

Customer

0000012234

0000043210

00000REPLU

67890

123445

Total length of the customer is 10 always, what i need to do is if the length is less than than it will automatically add zeros before the number,

e.g. in my case 67890 shud be 0000067890

and 123445 shud be 0000123445

Re: Logic Help

Chanty4u — Wed, 16 Mar 2016 10:04:47 GMT

Num(customer,'0000')

Re: Logic Help

MK_QSL — Wed, 16 Mar 2016 10:04:59 GMT

Load Num(Customer,'0000000000') as Customer Inline

[

Customer

0000012234

0000043210

00000REPLU

67890

123445

];

Re: Logic Help

sunny_talwar — Wed, 16 Mar 2016 10:06:52 GMT

Try this:

TAB1:

LOAD *,

If(Len(Customer) < 10, Repeat(0, 10 - Len(Customer)) & Customer, Customer) as CUS;

LOAD * INLINE

[

Customer

0000012234

0000043210

00000REPLU

67890

123445

];

Re: Logic Help

MK_QSL — Wed, 16 Mar 2016 10:09:15 GMT

Load

If(Len(Customer) < 10, Text(Repeat(0,10-Len(Customer)))&Customer,Customer) as Customer

Inline

[

Customer

0000012234

0000043210

0000REPLU

67890

123445

];

Ohhh... Sunny T already replied the same...

Re: Logic Help

abhaysingh — Wed, 16 Mar 2016 10:15:38 GMT

Hi Guys ,

below also working for me

LEFT('0000000000', 10 - LEN(CUSTOMER)) & CUSTOMER

Re: Logic Help

ali_hijazi — Wed, 16 Mar 2016 10:18:48 GMT

you can use the repeat function

Load repeat('0',10-Len(Customer) & Customer as Customer

from your_data_source

Re: Logic Help

abhaysingh — Wed, 16 Mar 2016 10:45:15 GMT

tried but not working

Re: Logic Help

sunny_talwar — Wed, 16 Mar 2016 10:46:41 GMT

I think there is missing parenthesis, try this:

LOAD Repeat('0',10-Len(Customer)) & Customer as Customer

Re: Logic Help

Anonymous — Wed, 16 Mar 2016 11:58:31 GMT

T1:

LOAD * INLINE [

Customer

0000012234

0000043210

0000REPLU

67890

123445

];

T2:

NoConcatenate Load

Customer,

Repeat('0',10-len(Customer))&Customer as New

Resident T1;