Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
shanmurugesh
Partner
Partner

How to filer the data while do Binary Load??

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

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

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

View solution in original post

3 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

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

View solution in original post

shanmurugesh
Partner
Partner
Author

thanks marcus,

let we try that.

maxgro
MVP
MVP

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