Insert data to existing partition

Community Support
1

Is there a func that I can use to insert data to a partitioned table?  Similar to .Q.dpft except I dont want to overwrite the table each time, instead I want to add to it.

Thanks.

2

You can upset to the specific partition on disk:

:/path/2017.03.07/table upsert .Q.en[:/path] table

Marcus

3

Hi

upsert will allow you to append records to a partitioned table You will have to enumerate any symbols manually against the sym file

Jason

4

http://code.kx.com/wiki/JB:KdbplusForMortals/splayed\_tables#1.2.4.1\_Appending\_Records

should be what you want

you can just create a wrapper over it to enable you to pass date, table, records

f:{[root;d;t;r] .Q.dd[root;(d;t;`)] upsert r }

(add .Q.en if you have syms)

f[:.;2017.01.01;t;(10?10)]

HTH,

Sean

5

Thanks very much Sean.

6

Got it, thanks Marcus.