how to join or mapping?

Anonymous — Thu, 10 Aug 2017 15:32:01 GMT

Table1

id	name
1	A
2	B
3	C
4	D

Table 2:

id	value
1	10
3	11

Table 3:

name	value
B	20
D	22

how to load three tables into one table?

here is my code

Table1:

LOAD * INLINE [

id, name

1, A

2, B,

3, C

4, D

];

NoConcatenate

Table2:

LOAD * INLINE [

id, value

1, 10

3, 11

];

NoConcatenate

Table3:

LOAD * INLINE [

name, value

B, 20

D, 22

];

map1:

mapping LOAD id,

value

Resident Table2;

map2:

mapping LOAD name,

val

Resident Table3;

Data:

LOAD ids,

name,

alt(ApplyMap('map2',name,Null()),ApplyMap('map1',id,Null())) as value

Resident Table1;

Re: how to join or mapping?

Oleg_Troyansky — Thu, 10 Aug 2017 16:54:32 GMT

Looks about right, with a couple of comments:

1. The keywords NoConcatenate appear to be out of place, and they are not needed here.

2. At the end of the script, drop your raw tables 1, 2, 3.

3. In the last load statement, you misspelled the field id.

the rest should work just fine.

Cheers,

Oleg Troyansky

Upgrade your Qlik skills with my book QlikView Your Business: An Expert Guide to Business Discovery with QlikView and Qlik Sense

topic Re: how to join or mapping? in QlikView

how to join or mapping?

Re: how to join or mapping?