topic Re: Mapping in QlikView

Mapping

Singh — Sun, 22 Apr 2018 19:42:37 GMT

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

Re: Mapping

olivierrobin — Mon, 23 Apr 2018 15:29:27 GMT

hello

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

ex:

load anslogin as login_id ...

Re: Mapping

Singh — Tue, 24 Apr 2018 05:35:46 GMT

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.

Re: Mapping

olivierrobin — Tue, 24 Apr 2018 15:23:38 GMT

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

Re: Mapping

sasiparupudi1 — Fri, 27 Apr 2018 19:50:13 GMT

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);

Re: Mapping

Singh — Mon, 07 May 2018 05:58:46 GMT

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