dbload function

Topics: Database Management, Times Series
Sep 20, 2014 at 4:52 PM
Hi Jaromir

a simple question about dbload function. how can i use it to load just the time serie data of a one variable from csv file than contain 30 variable ..
Coordinator
Sep 20, 2014 at 6:08 PM
Edited Sep 20, 2014 at 6:13 PM
Just load the entire file and then delete the variables you don't want.

See
help dbload
for details on how to use dbload.
Coordinator
Sep 22, 2014 at 2:28 PM
Hi

Currently, dbload can be used only to load all the tseries from the CSV file. You can, though, then use the times operator * to keep only the database entries you want. For instance
d = dbload('mydata.csv');
d = d * {'x1','x2','x3'};
will load all the series from the CSV file, while the second line will retain only series named x1, x2, x3, and remove all other series.

I will create an option in the dbload function to make the selection.

Best,
Jaromir
Sep 22, 2014 at 2:55 PM
thank you for clarifying. Mr Jaromir

all respect.