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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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