Discussion Board for collaboration on QlikView Scripting.
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?
FROM XML "StockQuote"
DROP TABLE RestConnectorMasterTable;
I've tried many options, please, help.
1 : RestConnectorMasterTable:
Load * Where Status='SUCCESS';
FROM XML "StockQuote";
where Status = 'SUCCESS';
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?
I did not remember properly Some where I read that you can't write where clause on XML data...