Qlik

[srirangavaram]

I need to achieve the following,

How to delimit the field which is combined in apply map. Please help.

[avinashelite]

Did not get your question , add some sample data and illustrate what your trying to achieve 

[srirangavaram]

HI,

There are 3 fields in mapping table, one is mapping id, remaining two fields were combined to achieve applymap. 

Mapping table                       Destination table

id                                                  Loc_Reg

location& '/'& region

as Loc_Reg

I want Loc_Reg  field to  region and location in the destination table.

[avinashelite]

Try like this 

SubField(Loc_Reg,'/',1) as Location,

SubField(Loc_Reg,'/',2) as Region,