Mapping is not working in below sceinero?

[#1]

Hi team,

iam applying mapping in bleow sceinero but mappin is not working  and also i applyed applymap that is also not working

please helpme  

TEAM:

Mapping LOAD
     [EDU Field Execution Team],
     [Sales Sub Region2]
FROM
[graphyQVD.xlsx]
(ooxml, embedded labels, table is FieldTeam_Mapping);

MAP   Sales Region] using TEAM;

GEO:
LOAD
     [Sales Sub Region],
       [Sales Region],
   
FROM
Geo.qvd(qvd);

[sushil353]

Try this:

TEAM:

Mapping LOAD
     [EDU Field Execution Team],
     [Sales Sub Region2]
FROM
[graphyQVD.xlsx]
(ooxml, embedded labels, table is FieldTeam_Mapping);

Table2:

LOAD

     [Sales Sub Region],

       ApplyMap('TEAM',[Sales Region]) as map_region,

[Sales Region],

FROM

Geo.qvd(qvd);

Note: make sure that here coulmn 1 of TEAM table will be compared and coulmn 2 value will be replaced.

[#3]

Hi Sushil,

Its not working.,....

[sushil353]

Please post the sample application and data.

[sushil353]

do you have matching data in

[EDU Field Execution Team] and [Sales Region] fields?

[#6]

yes matching data is there