topic Re: Stuck with the task please do needful on Appending in QlikView

Stuck with the task please do needful on Appending

Wed, 10 Sep 2014 18:40:18 GMT

struck with the work need to get desired o/p as follows :-

written below code '0'&[Rep Office] as [Rep Office],
'0'& Currency as Currency ,
'0'&[Manager]as [Manager],

but it is not exactly getting desired o/p:

Suppose Office Dimension should have '011' for all columns it should check if 11<--011 like that 011<-011 no Zero to be append

Input:

Office	Currency	Manager	Major
11	02	1	01
011	2	1	01
011	2	01	1
11	02	01	1
11	02	01	1

Desired o/p:

Office	Currency	Manager	Major
011	02	01	01
011	02	01	01
011	02	01	01
011	02	01	01

Re: Stuck with the task please do needful on Appending

ashfaq_haseeb — Wed, 10 Sep 2014 19:14:14 GMT

Like This.

LOAD num(Office,'000') as Office,
  rowno() as Key,
  num(Currency,'00') as Currency,
  num(Manager,'00') as Manager,
   num(Major,'00') as Major
FROM
[http://community.qlik.com/thread/132816]
(html, codepage is 1256, embedded labels, table is @1);

Regards

ASHFAQ

Re: Stuck with the task please do needful on Appending

Wed, 10 Sep 2014 19:39:37 GMT

Thanks for your help it works for me .

Re: Stuck with the task please do needful on Appending

ashfaq_haseeb — Wed, 10 Sep 2014 19:41:12 GMT

Hi,

Can you close this thread by marking it as answer.

Regards

ASHFAQ