topic Re: Problem with Mapping in QlikView

Problem with Mapping

Fri, 24 Apr 2015 12:19:50 GMT

id:

mapping LOAD fil_id,

New_id

FROM

FilChange.xls

(biff, embedded labels, table is Sheet1$);

LOAD,

fil_id,

ApplyMap('id',fil_id) as New_id,

FROM

(qvd);

Fil.QVD looks like:

Nr.	fil_id	addr_id	info1	info2	info3
1	10	0	12	12	12
2	10	1	24	24	24
3	14	0	12	12	12

FilChange.xls looks like:

fil_id	New_id
10	Store1
14	Store2

Now I reload and get two list boxes, one for fil_id and one for New_id and I would suspect that fil_id shows 10,14 and New_id shows Store1 and Store 2, but... New_id also shows 10,14. What goes wrong?

Re: Problem with Mapping

sunny_talwar — Fri, 24 Apr 2015 12:31:08 GMT

Working for me. Have a look at it (PFA)

id:

Mapping LOAD fil_id,

New_id

FROM

[https://community.qlik.com/thread/161590]

(html, codepage is 1252, embedded labels, table is @2, filters(

Remove(Row, Pos(Top, 4))

));

LOAD Nr.,

fil_id,

addr_id,

info1,

info2,

info3,

ApplyMap('id',fil_id) as New_id

FROM

[https://community.qlik.com/thread/161590]

(html, codepage is 1252, embedded labels, table is @1);

Best,

Sunny

Re: Problem with Mapping

Anonymous — Fri, 24 Apr 2015 12:33:09 GMT

The expectation is correct... I suspect that '10' in one table is not the same as '10' in another. Maybe string vs. number. Can you try this:

id:
mapping LOAD text(fil_id),
New_id
FROM
FilChange.xls
(biff, embedded labels, table is Sheet1$);

LOAD,
fil_id,
ApplyMap('id',text(fil_id)) as New_id,
...

Re: Problem with Mapping

Gabriel — Fri, 24 Apr 2015 12:33:38 GMT

Hi,

Is New_id in the excel file and defined. It looks like that field is not in the excel file. Post both excel file and a sample qvw file please.

Re: Problem with Mapping

buzzy996 — Fri, 24 Apr 2015 12:35:11 GMT

USE THIS,

Re: Problem with Mapping

Fri, 24 Apr 2015 12:37:56 GMT

You don't want to know what I've been trying for something so simple. Won't happen again. Thank you!