cancel
Showing results for 
Search instead for 
Did you mean: 

Importing data from csv file

LearnerKDB
New Contributor II

fileName:hsym `$"C:/users/data.csv"

show t:("SSDD";enlist",") 0: fileName

After running these two lines iam getting below error:

OS reports no such file or directory. But data.csv is there in the above location. 

1 ACCEPTED SOLUTION

davidcrossey
Moderator Moderator
Moderator

Hi LearnerKDB,

Can you confirm the following points:

  • The file is in C:/users and not C:/users/{USER_NAME}/ ? Typically you can't write files directly to C:/Users/ (note the capital 'U' as well), as this is a permissioned directory on Windows.
  • Are using kdb/q on Windows directly, or are you using WSL? (Path here would be /mnt/c/users/data.csv)

Kind regards,

David

View solution in original post

1 REPLY 1

davidcrossey
Moderator Moderator
Moderator

Hi LearnerKDB,

Can you confirm the following points:

  • The file is in C:/users and not C:/users/{USER_NAME}/ ? Typically you can't write files directly to C:/Users/ (note the capital 'U' as well), as this is a permissioned directory on Windows.
  • Are using kdb/q on Windows directly, or are you using WSL? (Path here would be /mnt/c/users/data.csv)

Kind regards,

David