topic Store data in another table in QlikView

Store data in another table

Dayna — Fri, 13 Nov 2009 22:23:20 GMT

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

Store data in another table

Fri, 13 Nov 2009 22:31:19 GMT

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

Store data in another table

hector — Fri, 13 Nov 2009 22:42:03 GMT

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