Stuck with the task please do needful on Appending

[#1]

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

[ashfaq_haseeb · Accepted solution]

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

[#3]

Thanks for your help it works for me .

[ashfaq_haseeb]

Hi,

Can you close this thread by marking it as answer.

Regards

ASHFAQ