Hi Pratap,As I mentioned before, one way to fix this would be to
manually add the headers to the csv file.However, you can do the
following to accomplish adding the data into the existing table:With a
csv file with no headers:1,x,34,y,67,z,9You can l...
Hi Pratap,If you would like to insert the csv into an already existing
table, you can user upsert or ,:For example:With a csv file with the
contents:a,b,c1,x,34,y,67,z,9In a q session I have a table defined
as:q)table:([]a:`int$();b:`$();c:`int$())q)...
Hi S. Pratap,In addition to your solution, I have further information to
help clarify your problem.I was able to replicate your error using your
table.s file:q)\l table.s`Persons" "'PersonID [2] C:\q\s.k:22:
.s.e:k){$[~#r::v'r@:&~(_r::w
x)in$`as`by`a...
Hi S Pratap,If you change your '.sql' file extension to '.s' that
contains, for example:~ $ more t.sCREATE TABLE table_name ( column1 int,
column2 varchar, column3 float, column1600 varchar )You can load the
file in a q session as follows:q)\l sqltab...
Hi Diarmaid,If you are just trying to create a directory that you are
already in, where you started q, then the following should work:\mkdir
fooIf you are trying to create a directory in the folder where q is
installed, then I think you can use:\mkdi...
