Problem with Mapping

[#1]

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?

[sunny_talwar]

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

[Anonymous · Accepted solution]

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,
...

[Gabriel]

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.

[buzzy996]

USE THIS,

[#6]

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