Store data in another table

[Dayna]

Hello!

I am hoping that you can help me, it may be an easy one... (hopefully!)

Basically, I have a table with a bunch of different bits of data, i.e. Inventory, Quantity, Part, Dates, etc.. Each catagory has a reference number. What I am trying to do, is for each reference number dump all of the data into a table. I.e. If reference no = 2, then dump data into table Date, if reference no = 3, then dump data into table Part, etc...

If you could help me with this, it would be most appreciated!!!!!!

Kind Regards,

Dayna

[#2 · Accepted solution]

Reference:

Noconcatenate

LOAD * from MyTable where reference=2;

Store Reference into x:\reference.qvd;

Part:

Noconcatenate

LOAD * from MyTable where reference=3;

And so on...

Rgds,

Sébastien

[hector]

hi, you can try drop table(s) too, this will eliminate the tables from memory, a common use is:

t1:
Load
*
from ....;
store t1 into t1.qvd;
drop table t1;

t2:
Load
*
from ....;
store t2 into t2.qvd;
drop table t2;

rgds