Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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';