Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
You can't do that with a mapping, instead just use almost the same load as a linked table to your (in my example named) Cadastral field.
OtherData:
Load * Inline [Cadastral
Kukwuaba Cadastral
Gudu Cadastral
Durumi Cadastral
];
Area:
load * inline [Cadastral, Zone
Kukwuaba Cadastral, Zone A
Gudu Cadastral, Zone A
Durumi Cadastral, Zone A
Durumi Cadastral, Zone B
Wuye Cadastral, Zone B
Jabi Cadastral, Zone B
Utako Cadastral, Zone B
Mabuchi Cadastral, Zone B
Jahi Cadastral, Zone B
Kado Cadastral, Zone B
Dakibiyu Cadastral, Zone B
Kaura Cadastral, Zone B
Duboyi Cadastral, Zone B
Gaduwa Cadastral, Zone B
Dutse Cadastral, Zone B
Katampe Ext Cadastral, Zone B
];
Use 2 lines:
Durumi Cadastral, Zone A
Durumi Cadastral, Zone B
I have done this before now. Didn't work
Correct me if I'm wrong, but I think an applymap will only map the first matching value
I have to use ApplyMap() statement to align to my table.
Yes
But there could be a way around this
Load it again using reisdent load and do subfield with delimiter on Zone.
subfield(FieldName, '&'), it will make 2 records.
Not clear