Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Can we put some conditions while writing storing a table into QVD or any other alternative to the same.
Regards
Kushal Thakral
Try like this :
create a new table by resident load with a condition where flag =0 and store the same table to QVD
load *
....
...
...
from tablename where(match(flag,1))=0;
store tablename into name.qvd
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
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
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;
Can you share script.
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
Oh yes drop table table1; in the end
yea now it is working
Thanks
Cool Happy Learning