performance - KDB+ / Q Syntax optimizations to oneliners

Question

I am definitly a q-mortal. I would even say a q-baby. Well I have some question how to put together my code from separate lines to a one-liner. I guess there is a way more elegant solution than mine.

1. How to write the following statements in one line:

   q)t1:(3#3)?:`8
   q)t1[;0]:`abc
   

2. In this table creation, how can I add another column which I have as list (like with the command ([]id:id_list;data:data_list;.....)). Till now I am creating another table and doing an inner join on them. I guess that's not very efficient:

   `id xkey update id:i from flip (`row1`row2!(1 2;3 4))
   

Answer 1

For the 1st one you may do:

q)`abc,/:(3#2)?:`8
abc jognjhck cihanjhp
abc hkpblald aeajbddp
abc blmjhgah ooeiogdj

For 2nd one you may treat the table as a dictionary:

q)tb
row1 row2
---------
1    3   
2    4   
q)(tb`id): 5 6
q)tb
row1 row2 id
------------
1    3    5 
2    4    6