topic How to filer the data while do Binary Load?? in QlikView

How to filer the data while do Binary Load??

shanmurugesh — Thu, 01 Dec 2016 10:17:57 GMT

Hi guys,

We are facing one small problem while do binary load.

we needs to do filter some data based on the condition while do binary load..

for this, i gone through many of our threads , but we counldn't get result..please advice..

Scenario :

Load data through binary load

in that, filter all current month data or show data only till previous month..

Note:

we are using common DM (Data model) for two applications..so not able to filter the data in DM itself.

Thanks and regards,

Murugesan.N

Re: How to filer the data while do Binary Load??

marcus_sommer — Thu, 01 Dec 2016 15:41:56 GMT

There is no possibility to filter a binary-load. But you could after them loading your tables again with where-clauses and/or dropping fields and tables - and of course you could also add new data.

- Marcus

Re: How to filer the data while do Binary Load??

shanmurugesh — Tue, 06 Dec 2016 09:47:47 GMT

thanks marcus,

let we try that.

Re: How to filer the data while do Binary Load??

maxgro — Tue, 06 Dec 2016 10:02:10 GMT

Some options:

- at the end of the DM qvw store the tables in .qvd files and in the 2 applications use different filters in the where section of the load

- after binary load you can do a (noconcatenate) resident load with a where filter on the date field, then drop the original table

- after binary load you can create a table with the needed dates (or months) and use right keep to filter

Hope it helps