Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
penkerton
Contributor
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
vishsaggi
Champion III
Champion III

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
vishsaggi
Champion III
Champion III

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;

kfoudhaily
Partner - Creator III
Partner - Creator III

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

then E left join F

QlikView Qlik Sense consultant