topic Re: WHERE Statement in REST Connection in QlikView

WHERE Statement in REST Connection

Anonymous — Tue, 07 Aug 2018 12:02:02 GMT

Hello,

After loading data using a REST Connector I need to include a WHERE statement as follows, but it's not working. It returns an error that i can't understand. Is it possible to include a WHERE there?

RestConnectorMasterTable:

SQL SELECT

"Status",

"High",

"Low",

"Open"

FROM XML "StockQuote"

WHERE [Status]='SUCCESS';

[StockQuote]:

LOAD [Status],

[High],

[Low],

[Open]

RESIDENT RestConnectorMasterTable;

DROP TABLE RestConnectorMasterTable;

I've tried many options, please, help.

Thanks,

Alazne.

Re: WHERE Statement in REST Connection

PrashantSangle — Tue, 07 Aug 2018 12:17:28 GMT

Try below

1 : RestConnectorMasterTable:

Load * Where Status='SUCCESS';

SQL SELECT

"Status",

"High",

"Low",

"Open"

FROM XML "StockQuote"

WHERE [Status]='SUCCESS';

SQL SELECT

"Status",

"High",

"Low",

"Open"

FROM XML "StockQuote";

[StockQuote]:

LOAD [Status],

[High],

[Low],

[Open]

RESIDENT RestConnectorMasterTable

where Status = 'SUCCESS';

DROP TABLE RestConnectorMasterTable;

Regards,

Re: WHERE Statement in REST Connection

Anonymous — Tue, 07 Aug 2018 12:47:24 GMT

Thanks, it seems that preceding load works, but i undestand that preceding load filters data after loading it.

What I need, because of the data volume, is to filter data while loading (SQL SELECT) and thus reduce the volume of downloaded data. Is that possible?

Re: WHERE Statement in REST Connection

PrashantSangle — Tue, 07 Aug 2018 12:56:06 GMT

Hi,

I did not remember properly Some where I read that you can't write where clause on XML data...

Regards,