topic Re: Map this code segment to assign an identifier to two variable in QlikView

Map this code segment to assign an identifier to two variable

Thu, 18 Jun 2015 11:40:31 GMT

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.

Re: Map this code segment to assign an identifier to two variable

stigchel — Thu, 18 Jun 2015 11:55:32 GMT

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

];

Re: Map this code segment to assign an identifier to two variable

jonathandienst — Thu, 18 Jun 2015 11:58:47 GMT

Use 2 lines:

Durumi Cadastral, Zone A

Durumi Cadastral, Zone B

Re: Map this code segment to assign an identifier to two variable

Thu, 18 Jun 2015 12:04:27 GMT

I have done this before now. Didn't work

Re: Map this code segment to assign an identifier to two variable

stigchel — Thu, 18 Jun 2015 12:04:34 GMT

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

Re: Map this code segment to assign an identifier to two variable

Thu, 18 Jun 2015 12:14:00 GMT

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

Re: Map this code segment to assign an identifier to two variable

Thu, 18 Jun 2015 12:15:02 GMT

Yes

Re: Map this code segment to assign an identifier to two variable

Thu, 18 Jun 2015 12:16:26 GMT

But there could be a way around this

Re: Map this code segment to assign an identifier to two variable

Thu, 18 Jun 2015 12:21:36 GMT

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

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

Re: Map this code segment to assign an identifier to two variable

Thu, 18 Jun 2015 12:27:39 GMT

Not clear

Re: Map this code segment to assign an identifier to two variable

stigchel — Thu, 18 Jun 2015 12:28:35 GMT

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)

Re: Map this code segment to assign an identifier to two variable

Thu, 18 Jun 2015 12:40:30 GMT

PFA

Re: Map this code segment to assign an identifier to two variable

Thu, 18 Jun 2015 12:49:57 GMT

This doesn't give proper association of your data

Re: Map this code segment to assign an identifier to two variable

Thu, 18 Jun 2015 12:58:08 GMT

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;

Re: Map this code segment to assign an identifier to two variable

stigchel — Thu, 18 Jun 2015 13:26:11 GMT

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?