Conditional join

[#1]

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

[MK_QSL · Accepted solution]

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;

[#3]

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

[engishfaque]

Dear Sebastian,

Find attached qvw.

Kind regards,

Ishfaque Ahmed