If/CASE statement in load with fields from two tables

matthewp — Fri, 04 Dec 2015 11:13:36 GMT

I have a load statement below:

[code]

TABA:

LOAD [Number] AS [ID Number],

[Type] AS [AType]

FROM

(qvd);

LEFT JOIN(TABA)

TABB:

LOAD [Number] AS [ID Number],

[Type] AS [BType]

FROM

(qvd);

[\code]

Now this works fine, however i want to put in the load script

CASE WHEN [AType] IS NULL THEN [BType] ELSE NULL

However i can get it to work.

I have tried :

TABA:

LOAD [Number] AS [ID Number],

[Type] AS [AType]

FROM

(qvd);

LEFT JOIN(TABA)

TABB:

LOAD [Number] AS [ID Number],

[Type] AS [BType],

if(IsNull(TABA.Type),TABB.Type,Null) AS [NewType]

FROM

(qvd);

Also Tried:

TABA:

LOAD [Number] AS [ID Number],

[Type] AS [AType]

FROM

(qvd);

LEFT JOIN(TABA)

TABB:

LOAD [Number] AS [ID Number],

[Type] AS [BType],

if(IsNull(AType),BType,Null) AS [NewType]

FROM

(qvd);

Re: If/CASE statement in load with fields from two tables

matthewp — Mon, 07 Dec 2015 08:50:19 GMT

bump

topic Re: If/CASE statement in load with fields from two tables in QlikView

If/CASE statement in load with fields from two tables

Re: If/CASE statement in load with fields from two tables