Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to achieve the following,
How to delimit the field which is combined in apply map. Please help.
Did not get your question , add some sample data and illustrate what your trying to achieve
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.
Try like this
SubField(Loc_Reg,'/',1) as Location,
SubField(Loc_Reg,'/',2) as Region,