Binary Load: Can't we provide where clause in it?

[#1]

Guys,

Is that possible to write WHERE Condition for Binary Load?

Also can we write IF ELSE Conditions?

IF v6months THEN

BINARY C:\6MonthsData.qvw;

ELSE

BINARY C:\12MonthsData.qvw;

END IF;

[ramoncova06]

No, the binary load has to be the first statement in the document, though you are able to use keep and left joins afterwards

[#3]

Could you please provide any sample script for left join with Binary load.

[ramoncova06]

let's say you have a binary called test with a fact table , and you want to only keep the info with year 2014, this is something you can do

Binary test.qvw;

tempinline:

right keep (fact)

load * Inline

[year,

2014];

drop table tempinline;

[#5]

Can't we do same thing for a .QVW application which is having 9 Dimensions data and one fact Table (FT) with 2 years of data and want to restrict fact data for an year only .

Binary Sales_Report.qvw;

tempinline:

right keep (FT)

load * Inline

[year,

2014];

Is this possible?

[ramoncova06]

when you say 9 dimensions, you mean 9 dimension tables ? or fields ?

in theory you could do this for whatever tables you want as long as you match whatever field you want to your inline's, you could even do where's to it, but I feel that the keep is a lot faster

[#7]

Yes, 9 Dimensions means 9 Dimension tables.

What I am trying to do is: I have .qvw application which is having 2 years of data. So from this application if I want to fetch only recent 6 months data (based on a DATE column from fact) and can keep into another .qvw application.

[#8]

Also there is any action available to .qvw application which may give us control to load the requested data into memory.

For example:

Initially, my application holds only recent 6 months data (1-6) and one user wants to see recent 12 months so he/she should click/enter somewhere in application and then another 6 months (7-12) data should append to recent 6 months (1-6) data in same application (don't want to open another .qvw) .

This way we should save RAM space and no of concurrent may increase and on request we may see till 2 years of data.

Please suggest.

[ramoncova06]

Never done this and I don't think possible

[#10]

Disappointing.

How about partial load.  Can we achieve this by partial load?

Is that possible to Append/Add data to QlikView Application based on user request.