Binary qvw loading issues

[remo0017]

Hello Everyone,

I have been having issues in field selection & applying filters [Where conditions] on the fields from the Binary qvw files.

I am trying to use the below snippet on top

Binary [..\..\XXXX.qvw];

But I would like to use something like this for my requirements by using above binary qvw file.

LOAD

a,

b,..;

SQL SELECT

a,

b,..

from table or Binary

where a='XXX' and b='YYYY';

Your help is much appreciated

[rwunderlich]

What does "from table or Binary" mean?

-Rob

[Anil_Babu_Samineni]

First of all, You can't use Binary script to load statement. So, here you are expecting on what? Would you elaborate more. I assume, You have binary data model and that you want to use one directory table to load statement special variation. Is this you are expecting. Please let us know which demonstrates the issue

[fkeuroglian]

Hi

I suppose that you want to exclude (using where condition) some information that you bring in your binary before.

If you want to do that, you can do:

Binary [..\..\XXXX.qvw];

Table1:

LOAD

a,

b,..;

SQL SELECT

a,

b,..

resident tableOriginal

where a='XXX' and b='YYYY';

Example: tableOriginal is a table that you have in your qvw binary, and Table1 will be the result of tableOriginal with the where conditions.

Hope help

Fernando

[its_anandrjs]

Hi,

Here you mean to say you want to create a table which is based on the Binary load or Model.

Regards,

Anand

[Peter_Cammaert]

A BINARY statement loads the entire data model from the specified document into RAM, including such - probably unwanted - stuff as Section Access etc. There's no escaping from that, it's how the BINARY statement works.

If you want to add or weed out tables/records/fields, you'll have to explicitly specify the changes after the BINARY statement using DROP or LOAD statements. IMHO Section Access information cannot be changed.

AFAIK the binary statement is conceived as some sort of DataMart fast loading technique.

See here for more info: Binary ‒ QlikView

[kamal_sanguri]

Use

Noconcatenate

Table1:

LOAD

a,

b

resident <tablename>

where a='XXX' and b='YYYY';

Drop Table <tablename>;

Replace the <tablename> with the name of the table (which you can by looking at the data model by pressing Ctrl + T)

Please note: It is necessary to have Noconcatenate keyword before you load Table otherwise it will load the data and add it to original table. Also you can have Drop table statement, if you now don't need original table.

[remo0017]

We have this situation for which we are using the Binary

LOAD A1,A2,A3;
SQL SELECT A1, A2,A3 from table1;

LOAD B1,B2;
SQL  SELECT B1, B2 from table2;

AAA:
LOAD c1,c2,c3,c4;
select c1,c2,c3,c4 from table3;

outer join (aaa)

LOAD c,d;
SQL select c,d from table4;

table3 is joined with table1, table2 by c1,c2, but table1 & table2 doesn't have anything to join in common.

How do i apply where condition like this table1.A3 < table2.B2 and still get all the data from table3 & table4 ?

We thought to use this with some Binary and its so confusing

[remo0017]

I have data from multiple tables which is being pushed into extract script which I am using as a Binary [Binary [YYYY.qvw] to load all the data into the report,

Now I have to create barchart & straight table by applying filters [where conditions] but I don't understand how I can use the fields from binary file to apply these filters.

Lets say I have A1 from table1 and B1 from table2 which are common and are part of this Binary file

Now how can I apply a condition like this

where table1.A1=table2.B2 ??