New Contributor
since ‎2014.01.12

User Statistics

  • 51 Posts
  • 0 Solutions
  • 0 Kudos given
  • 0 Kudos received

User Activity

Hi,I was required in my scripts to insert null values for some column but because of number of columns were large, i thought to write a function that will give me such values. But somehow i was not able to find a direct way to find that null values f...
Hi,I am using q on windows. I have to compress tables at the time of splaying itself.For simplicity i have taken following example:.z.zd:(16;2;1)`:db/t/ set ([] ti:09:31:00 09:30:01 09:30:02 09:30:03; p:33 33.5 33.2 33.3)When i run above command i ge...
Hi,We have to write records of table to csv format. We were using following formatlinks: flip `str`intt`flt ! (("vReporter"; "vData"; "CDR"); (1000; 2031; 4098); (0.00001; 0.000001; 0.0000001))csv 0: linksIt will give following result:str,intt,fltvRe...
Hi,What is the right way to Delete/drop a splayed table?
Hi,I am splaying a file(5gb, 10M) that contains 117 column. In which 50 columns are Varchar. If i take all 50 columns as symbol then q(32 bit) restarts after memory full.What will be right way to load data as string. fun:{ddd:.Q.en[`:allsyms;]flip co...