Re: Simple Question About Loading Data From csv File

Community Support
1

First change the upload query tot he following:EURUSD:flip DTimeBidask!("ZFF"; enlist ",") 0: E:/System_Application/Dukascopier/EURUSD.csvThis will give each column a name and store the data with theircorrects type.Afterwards you can update the table by date and timeEURUSD:update DATE:date$DTime,TIME:time$DTime from EURUSDHTH,KimOn 10 Jul., 14:38, she wenhao <shewen…> wrote:> Dear All KDB+ Developer,>> Hope everything great for your guys.>> I am trying to load data of a csv file into KDB+ database. Here is the> structure of the data:>> https:>> As you may notice, it is Forex Tick data.>> I tried to load the data by the command below:>> EURUSD:(“SSS”; enlist “,”) 0: `E:/System_Application/Dukascopier/EURUSD.csv>> I just load three colume because the last two column is meaningless.>> And I check the result by EURUSD:>> https:>> The data seems ok. But the first column includes first part for date and> second part for time. I just wonder that how to split the first column into> a “DATE” and a “TIME” column? Thank you very much for your time and> patience first.>> SIncerely,>> Wenhao SHE</https:></https:></shewen…>

2

Dear Kim,

Thank you so much for quick reply.

I just tried your command.

And the result is a complaint:

`length

Do you have any idea about this? I believe it is very close to the right command.

Thanks lot again and waiting for your reply.

Best Regards,

Wenhao SHE

Now it is what I got:

3

Dear Kim,

The problem got solved and I would post whole codes I use:

EURUSD:(“ZFF”; enlist “,”) 0: `E:/System_Application/Dukascopier/EURUSD.csv;

EURUSD:DateTimeBid`Ask xcol EURUSD;

EURUSD:update Date:date$DateTime,Time:time$DateTime from EURUSD;

I took big advantage from you to accomplish this. Appreciate lot.

May you tell me about what does the “Z” in “ZFF” means, I  guess it is a abbreviation of a type of data, right? And your original command to load data still got `length complaints. May you tell me where it is wrong? 

Thanks again and have a nice day

Wenhao 

4

Don’t enlist the comma as doing this creates column headings from the first row of the csv

Try this:

EURUSD:flip datebidask!("ZFF";",") 0: E:/System_Application/Dukascopier/EURUSD.csv

5

Dear Tom,

Thank you very much and after removing the enlist, I could successfully load the data. Thanks lot. Thanks for words from Kim as well, I guess the enlist is the problem here.

Thank you very much again.

Best Regards,

Wenhao SHE