# Insert data to existing partition
**URL:** https://forum.kx.com/t/insert-data-to-existing-partition/11506
**Category:** Community Support
**Tags:** kdb-and-q
**Created:** [March 7, 2017, 4:39pm UTC](https://forum.kx.com/t/insert-data-to-existing-partition/11506 "2017-03-07T16:39:00Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@hoffmanroni1](https://forum.kx.com/u/hoffmanroni1)
#### Post date: [March 7, 2017, 4:39pm UTC](https://forum.kx.com/t/insert-data-to-existing-partition/11506/1 "2017-03-07T16:39:00Z")
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.
---
### Author:  [@clarkem8](https://forum.kx.com/u/clarkem8)
#### Post date: [March 7, 2017, 4:49pm UTC](https://forum.kx.com/t/insert-data-to-existing-partition/11506/2 "2017-03-07T16:49:00Z")
You can upset to the specific partition on disk:
`:/path/2017.03.07/table upsert .Q.en[`:/path] table
Marcus
---
### Author:  [@Jason\_Fealy1](https://forum.kx.com/u/Jason_Fealy1)
#### Post date: [March 7, 2017, 4:51pm UTC](https://forum.kx.com/t/insert-data-to-existing-partition/11506/3 "2017-03-07T16:51:00Z")
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
---
### Author:  [@sohagan](https://forum.kx.com/u/sohagan)
#### Post date: [March 7, 2017, 5:10pm UTC](https://forum.kx.com/t/insert-data-to-existing-partition/11506/4 "2017-03-07T17:10:00Z")
[http://code.kx.com/wiki/JB:KdbplusForMortals/splayed\_tables#1.2.4.1\_Appending\_Records](http://code.kx.com/wiki/JB:KdbplusForMortals/splayed%5C_tables#1.2.4.1%5C_Appending%5C_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
---
### Author:  [@hoffmanroni1](https://forum.kx.com/u/hoffmanroni1)
#### Post date: [March 7, 2017, 6:07pm UTC](https://forum.kx.com/t/insert-data-to-existing-partition/11506/5 "2017-03-07T18:07:00Z")
Thanks very much Sean.
---
### Author:  [@hoffmanroni1](https://forum.kx.com/u/hoffmanroni1)
#### Post date: [March 8, 2017, 1:15pm UTC](https://forum.kx.com/t/insert-data-to-existing-partition/11506/6 "2017-03-08T13:15:00Z")
Got it, thanks Marcus.