View source for Updating columns in a table without erasing data in other columns in the same row

=== '''Technical context''' ===
Data flow can be configured using out-of-the-box database table dataset save functionality. This functionality provides you with two options:

1) Only insert new records

2) Insert new and overwrite existing records
[[File:Data Flow Configuration wiki.png|alt=Data flow configuration in Pega Customer Decision Hub showing the options of inserting records.|border|none|frame|Out of the Box database table dataset save functionality in Pega Customer Decision Hub data flow.]]



When the '''Insert new and overwrite existing records''' option is selected, columns 1-5 will be overwritten to ''NULL'' when users try to insert values for columns 6-10. In other words, this option overwrites the entire row instead of updating the row, as shown in the illustration below:
[[File:Overwriting Existing Data in Adhocfield table.png|alt=Pega Customer Decision Hub data flow showing how to create a workaround to overwrite existing data in a data table.|none|thumb|900x900px|Overwriting existing data in adhocfield table]]