MAP

Wed, 02 Dec 2009 19:53:34 GMT

Dear All,

in this code:

tab:
lOAD *
iNLINE [
CAMPOb , CAMPOa
A ,bA
A,LL
AA, cc
GG , k
GG, z
A, VV
];

MAPPA:
MAPPING LOAD
CAMPOa AS CMP01
, CAMPOb AS CMP02
resident tab;

Load
CAMPOb,
ApplyMap('MAPPA' ,'A') as steff
resident tab;

I would to extract All field is linked to "A".

I axpected like result:

ba, LL, VV in a field called steff
, but doesn't work

Please some help?

Thanks

Slasj

MAP

Miguel_Angel_Baeyens — Wed, 02 Dec 2009 20:52:31 GMT

Hello,

You should use ApplyMap in the where statement instead of fields:

InitialData:LOAD * INLINE [ CAMPOb, CAMPOa A, bA A, LL AA, cc GG, k GG, z A, VV];Map:MAPPING LOAD CAMPOa AS CMP01, CAMPOb AS CMP02RESIDENT InitialData;Result:LOAD CAMPOa AS STEFFRESIDENT InitialDataWHERE ApplyMap('Map',CAMPOb) = 'A';

topic MAP in QlikView

MAP

MAP