Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table having 10 columns for example fileld1, field2,....field10.But i need to store only 5 coulms as according to my choice in qvd. Can it be possible?.if yes, then how can i achieve that.
Regards,
Vasudha.
Use this syntax
STORE
Field1,
Field2
FROM DataTable1 into [myFile1.qvd] (qvd);
Use this syntax
STORE
Field1,
Field2
FROM DataTable1 into [myFile1.qvd] (qvd);
Hi,
Yes you can.
in your sql query or load statement instead of * include those 5 field only
Regards,
If you want to do this dynamically, it would be better to export from a straight table. If you insist on doing this in the load script, then you will need to create a variable containing the comma-separated list of fields a,d then use that in the STORE statement - something like this (assuming that you are selecting values in a field called StoreFields:
STORE
$(StoreFields)
FROM DataTable1 into [myFile1.qvd] (qvd);
(This may show as a syntax error in the load script, but ignore that)
Field1, Field2 and Field3 are the fields of your choice in below table
Table:
load Field1
Field2,
Field3;
SQL SELECT *
FROM Table
store Table into Tablename.qvd;
drop table Table;