Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

MAPPING NOT WORK LOOKUP YES

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

1 Solution

Accepted Solutions
Luminary
Luminary

Re: MAPPING NOT WORK LOOKUP YES

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

2 Replies
Luminary
Luminary

Re: MAPPING NOT WORK LOOKUP YES

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

Not applicable

Re: MAPPING NOT WORK LOOKUP YES

thanks a lot

Community Browser