topic Re: MAPPING NOT WORK LOOKUP YES in QlikView

MAPPING NOT WORK LOOKUP YES

Mon, 29 Sep 2014 14:06:12 GMT

Please see atach.

if i load the same data from an excel work fine, if i do a lookup work fine.

If i load from sql (oracle tables not work)

Thanks in advance

simondachstr — Mon, 29 Sep 2014 14:08:53 GMT

In your mapping load, first load ZTRWE and then ZTRWE_ID e.g.:

MAP_ZTRWE:

MAPPING

LOAD

ZTRWE,

ZTRWE_ID;

SQL SELECT * FROM "WP_WEW"."ZTRWE_FC" WHERE ZTRWE='WP0027700242699005F0JZ';

BN_IL:

LOAD

ApplyMap('MAP_ZTRWE',ZTRWE )AS ZTRWE_ID_BONO,

ZTRWE AS ZTRWEIOTP;

SQL SELECT

ZTRWE

FROM "WP_HDE".RM4 WHERE ZTRWE='WP0027700242699005F0JZ';

Mon, 29 Sep 2014 14:15:07 GMT

thanks a lot