topic Re: Conditional join in QlikView

Conditional join

Tue, 02 Sep 2014 10:00:36 GMT

Hi guys,

Today I am struggling with below simple case:

tstable:

LOAD * INLINE [

ID, ID2

1, 01

2, 02

];

left join (tstable)

LOAD * INLINE [

ID2, VAL

01, alfa

02, beta

];

Concatenate (tstable)

LOAD * INLINE [

ID, ID2

3, 03

];

left join (tstable)

LOAD * INLINE [

ID2, VAL

03, gamma

];

Result of this script is:

And I would like to reach below result:

How to deal with this case Gentlemans?

Thank You & Regards,

Sebastian

Re: Conditional join

MK_QSL — Tue, 02 Sep 2014 10:05:03 GMT

tstable:

LOAD * INLINE [

ID, ID2

1, 01

2, 02

];

left join (tstable)

LOAD * INLINE [

ID2, VAL

01, alfa

02, beta

];

NoConcatenate

T2:

LOAD * INLINE [

ID, ID2

3, 03

];

Left Join

LOAD * INLINE [

ID2, VAL

03, gamma

];

Concatenate (tstable) Load * Resident T2;

Drop Table T2;

Re: Conditional join

Tue, 02 Sep 2014 10:30:48 GMT

Hi,

Try this one:

table1:

LOAD * INLINE [
ID2, VAL
01, alfa
02, beta
];

LOAD * INLINE [
ID2, VAL
03, gamma

];

tstable:

LOAD * INLINE [
ID, ID2
1, 01
2, 02
];
Concatenate (tstable)

LOAD * INLINE [
ID, ID2
3, 03
];

left join(tstable)
LOAD * Resident table1;

DROP Table table1;

hope it works.

Regards,

Biren Agrawalla

Re: Conditional join

engishfaque — Tue, 02 Sep 2014 11:09:05 GMT

Dear Sebastian,

Find attached qvw.

Kind regards,

Ishfaque Ahmed