KeyA if B IsNull - KeyB if B IsNotNull

Tue, 09 Sep 2014 15:18:31 GMT

Below is what my code looks like. What I am ultimately trying to accomplish is that table C should relate to table B if B_ID is populated, but table A if B_ID is not populated.

Link:

NoConcatenate

LOAD

A_ID

Resident TableA;

LEFT JOIN (Link)

LOAD

B_ID,

A_ID

Resident TableB;

LEFT JOIN (Link)

LOAD

C_ID,

A_ID

Resident TableC

WHERE IsNull(B_ID);

LEFT JOIN (Link)

LOAD

C_ID,

B_ID

Resident TableC

WHERE Not(IsNull(B_ID));

Re: KeyA if B IsNull - KeyB if B IsNotNull

JonnyPoole — Tue, 09 Sep 2014 15:48:48 GMT

If you get a chance , 3 sample files (table A,B,C) and 1 combined result (joined table) would help clarify the need.

topic KeyA if B IsNull - KeyB if B IsNotNull in QlikView

KeyA if B IsNull - KeyB if B IsNotNull

Re: KeyA if B IsNull - KeyB if B IsNotNull