Map this code segment to assign an identifier to two variable

[#1]

Hello,

See Mapping code segment, 'the highlighted part' Durumi Cadastral falls in both Zone A and Zone B. How do I make Durumi Cadastral fall in both zones.

[stigchel]

What do you mean you have to use ApplyMap() ? As I see it, you can either create more than one record in the lookup table (as in my example) or create two fields e.g Zone A and Zone B with a flag value (0,1 as in false true) where you use two mapping loads (one for Durumi in Zone A and one for Durumi in Zone B)

[#3]

PFA

[#4]

This doesn't give proper association of your data

[#5 · Accepted solution]

Use trim function.

NoConcatenate

Mapping: load

City,

trim(if(left(Zone,2)<>'Zo','Zone'&Zone,Zone)) as Zone

Resident Mapping_tmp;

DROP table Mapping_tmp;

[stigchel]

I'm curious, how is this table different from the Area table from my inline load? Where is the mapping that you have to have?