How to filer the data while do Binary Load??

[shanmurugesh]

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

[marcus_sommer · Accepted solution]

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

[shanmurugesh]

thanks marcus,

let we try that.

[maxgro]

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