topic Re: Conditions while storing QVD's in QlikView

Conditions while storing QVD's

kushalthakral — Wed, 14 Oct 2015 07:30:13 GMT

Hi All

Can we put some conditions while writing storing a table into QVD or any other alternative to the same.

Regards

Kushal Thakral

Re: Conditions while storing QVD's

gautik92 — Wed, 14 Oct 2015 07:31:22 GMT

what condition you want to write?can yu breif little more

Re: Conditions while storing QVD's

qlikviewwizard — Wed, 14 Oct 2015 07:33:18 GMT

Hi Kushal,

While storing in the sense, we can use where conditions and other filter conditions in script. We can store that table in QVD. Hope you got it. Thank you.

Re: Conditions while storing QVD's

kushalthakral — Wed, 14 Oct 2015 07:33:41 GMT

Conditions like where like what we write in case of Loading a table same can we apply while writing Store.

Regards

Kushal Thakral

Re: Conditions while storing QVD's

kushalthakral — Wed, 14 Oct 2015 07:34:44 GMT

Hi Arjun

i need to store it in Qlikview

Regards

Kushal

Re: Conditions while storing QVD's

gautik92 — Wed, 14 Oct 2015 07:36:32 GMT

you cannot write thos in store command i hope

Re: Conditions while storing QVD's

kushalthakral — Wed, 14 Oct 2015 07:36:54 GMT

then any alternative to the same

Re: Conditions while storing QVD's

avinashelite — Wed, 14 Oct 2015 07:37:17 GMT

With the STORE key word we cannot write any where condition, whiling building the table only you need to specify the same

Re: Conditions while storing QVD's

gautik92 — Wed, 14 Oct 2015 07:37:59 GMT

what is the scenario ?

you can write the where in load statement for which you are creating qvd

Re: Conditions while storing QVD's

kushalthakral — Wed, 14 Oct 2015 07:40:34 GMT

Scenario is like i have records in table with flag field containing 0 and 1 but while storing it into QVD i need only those having Flag 0

Regards

Kushal

Re: Conditions while storing QVD's

avinashelite — Wed, 14 Oct 2015 07:42:18 GMT

Try like this :

create a new table by resident load with a condition where flag =0 and store the same table to QVD

Re: Conditions while storing QVD's

gautik92 — Wed, 14 Oct 2015 07:43:52 GMT

load *

....

...

from tablename where(match(flag,1))=0;

store tablename into name.qvd

Re: Conditions while storing QVD's

kushalthakral — Wed, 14 Oct 2015 07:45:11 GMT

But while storing Resident table i am getting error it is saying table not found and i think i can store resident table in QVD

Re: Conditions while storing QVD's

nagarjuna_kotha — Wed, 14 Oct 2015 07:46:26 GMT

Table:

Load

ID,

Name

From...............

Store Table INTO "Ur Path"\Table.QVD(Qvd);

Note:

1.Afetr Store Name should be Your Table Name.

2.Ur Path is where you want store file.

3.Table is your choice ,you can give as you like Ex:Custmer or Emp_Table.

4.It will store only single table.

Is this you want know ?

Regards,
Nagarjuna

Re: Conditions while storing QVD's

avinashelite — Wed, 14 Oct 2015 07:48:53 GMT

see if you have same column names then it wil automatically concatenate with the previous table.

so try like this , either use NoConcatenate key word before the new table or rename all the field of new table .

LOAD A,

flag

from A;

NoConcatenate

LOAD A,

flag

resident A

where flag=0;

Re: Conditions while storing QVD's

nagarjuna_kotha — Wed, 14 Oct 2015 07:50:11 GMT

Can you share script.

Re: Conditions while storing QVD's

jyothish8807 — Wed, 14 Oct 2015 07:50:32 GMT

Hi Kunal,

Try like this:

table1:

load *

from Qv.qvd;

Noconcatenate

table2:

Load *

resident table1

where flag=0;

Store table2 into your [path];

drop table table1;

Regards

Re: Conditions while storing QVD's

jyothish8807 — Wed, 14 Oct 2015 07:51:17 GMT

Oh yes drop table table1; in the end

Re: Conditions while storing QVD's

kushalthakral — Wed, 14 Oct 2015 07:54:59 GMT

yea now it is working

Thanks

Re: Conditions while storing QVD's

avinashelite — Wed, 14 Oct 2015 07:57:29 GMT

Cool Happy Learning