MAPPING NOT WORK LOOKUP YES

[#1]

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 · Accepted solution]

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

[#3]

thanks a lot