How to append a row to a q table?
cheers
dinesh
How to append a row to a q table?
cheers
dinesh
Hi ,
?
?
If?u want to append all the rows of a table into another table then :
?
2 5? 89
3 6? 78
4 7? 67
6 89 12
7 87 34
8 67 23
?
But above is the case in which you can only append the row if the column name are same.?but if your column name are different then:
2 5 89 2 4 7
3 6 78 4 6 9
4 7 67 6 8 3
?
The above statement is?true for?appending one table columns to another.
?
again another one is upsert: which is always use for update the existing table row and insert new row into table:
?
q)t1:(x:1 2 3; y:4 5 6; z:10 20 30)
1 4? 10
2 5? 20
3 6? 30
4 10 30
?
?
Thanks
Hari Om
?