Mapping

[Singh]

hi,

I have one question that I want to map data from one excel file to another excel file in QlikView but the problem is that columns are different like I have to map login_id in one excel file with anslogin and orglogin i.e in different excel file.

files are attached.

thanks

[olivierrobin]

hello

why don't rename the columns so that they have same name in both files

ex:

load anslogin as login_id ...

[Singh]

Bro there are two field i.e anslogin and orglogin on which I have to map & if I Rename them then first thing happen is it will collapse both id's and second thing apply-map will not work as it won't works on aliases name.

[olivierrobin]

load your 1st file

then map the 2nd one on the 1st login

and map it on the 2nd login

load * from data

left join(data) load login_id as origlogin, .....

left join(data) load login_id as anslogin, .....

so you have all your 2 mappings

[sasiparupudi1]

May be try

T1:

LOAD EMP_ID,

     Login_ID,

     [LDAP ID],

     EMP_Name,

     Process

FROM

[list - Copy.xlsx]

(ooxml, embedded labels, table is Sheet1);

Left Join(T1)

LOAD Acwtime,

     Ansholdtime,

     Consulttime,

     Disptime,

     Duration,

     Ucid,

     Origlogin,

     Anslogin,

     If(Len(trim(Origlogin))>0,Origlogin,Anslogin) As Login_ID,

     Dialed_num,

     Calling_pty

FROM

[data - Copy.xls]

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

[Singh]

Thank you so much Sir,I already tried this but it's not working.