Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

penkerton
New Contributor

(A concatenate B) Join (C concatenate D)

Dears,

need your help.

Please let me know on how to script the following:

(TableA concatenate TableB) Join (TableC concatenate TableD)

In Discussions found only (TableA concatenate TableB) Join TableC, and still can't figure out how to script my request...


Kind regards,

Yury.

1 Solution

Accepted Solutions
Highlighted
vishsaggi
Esteemed Contributor III

Re: (A concatenate B) Join (C concatenate D)

Try below:

TabA:

LOAD * INLINE [

A, B

1, 3

2,4

];

TabB:

LOAD * INLINE [

A, B

3, 4

4, 5

];

TabC:

LOAD * INLINE [

C, D

1, 3

2,4

];

TabD:

LOAD * INLINE [

C, D

1, 3

2,4

];

Left Join(TabA)

Final:

LOAD *

Resident TabC;

Drop Table TabC;

View solution in original post

2 Replies
Highlighted
vishsaggi
Esteemed Contributor III

Re: (A concatenate B) Join (C concatenate D)

Try below:

TabA:

LOAD * INLINE [

A, B

1, 3

2,4

];

TabB:

LOAD * INLINE [

A, B

3, 4

4, 5

];

TabC:

LOAD * INLINE [

C, D

1, 3

2,4

];

TabD:

LOAD * INLINE [

C, D

1, 3

2,4

];

Left Join(TabA)

Final:

LOAD *

Resident TabC;

Drop Table TabC;

View solution in original post

Highlighted
kfoudhaily
Contributor III

Re: (A concatenate B) Join (C concatenate D)

create 2 temp tables E and F where you have the concatenation of each tables couples

then E left join F