Conditions while storing QVD's

[kushalthakral]

Hi All

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

Regards

Kushal Thakral

[avinashelite]

Try like this :

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

[gautik92]

load *

....

...

...

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

store tablename into name.qvd

[kushalthakral]

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

[nagarjuna_kotha]

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

[avinashelite · Accepted solution]

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 .

A:

LOAD A,

flag

from A;

NoConcatenate

B:

LOAD A,

flag

resident A

where flag=0;

[nagarjuna_kotha]

Can you share script.

[jyothish8807]

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

KC

[jyothish8807]

Oh yes drop table table1; in the end

[kushalthakral]

yea now it is working

Thanks

[avinashelite]

Cool Happy Learning