topic LOAD using SELECT statement inside a WHERE clause in QlikView

LOAD using SELECT statement inside a WHERE clause

Anonymous — Fri, 29 May 2015 13:25:53 GMT

When I execute this piece of code, the "Garbage after statement" error shows.

concatenate(Trade)

LOAD

TRADE_ID,

...

...

...

...

RESIDENT Trade_temp

WHERE TRADE_ID IN (SELECT trade_id FROM trade WHERE TRADE_YEAR < 2015 AND status=1);

I need to use the SELECT statement because I don't have all the information in the Trade.

Re: LOAD using SELECT statement inside a WHERE clause

Gysbert_Wassenaar — Fri, 29 May 2015 15:28:47 GMT

Perhaps like this:

Temp:

SELECT trade_id "temp_trade_id" FROM trade WHERE TRADE_YEAR < 2015 AND status=1);

concatenate(Trade)

LOAD

TRADE_ID,

...

...

...

...

RESIDENT Trade_temp

WHERE EXISTS (temp_trade_id, TRADE_ID);

Drop Table Temp;