Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Map this code segment to assign an identifier to two variable

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.

dd.JPG

1 Solution

Accepted Solutions
Not applicable
Author

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;

View solution in original post

14 Replies
stigchel
Partner - Master
Partner - Master

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

];

jonathandienst
Partner - Champion III
Partner - Champion III

Use 2 lines:

Durumi Cadastral, Zone A

Durumi Cadastral, Zone B

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

I have done this before now. Didn't work

stigchel
Partner - Master
Partner - Master

Correct me if I'm wrong, but I think an applymap will only map the first matching value

Not applicable
Author

I have to use ApplyMap() statement to align to my table.

Not applicable
Author

Yes

Not applicable
Author

But there could be a way around this

Not applicable
Author

Load it again using reisdent load and do subfield with delimiter on Zone.

subfield(FieldName, '&'), it will make 2 records.

Not applicable
Author

Not clear