> ## Documentation Index
> Fetch the complete documentation index at: https://domoinc-openapi-sync-dataflows.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Changing a Job from Upsert to Replace in Workbench 5

## Intro

Sometimes you need to update an Upsert Job to Replace. Follow these simple steps to update:

1. Un-protect the DataSet.
   * For newer versions of Workbench 5.

     <Frame>
       <img alt="1.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/wsUUuFj2iQGL8oiS/images/kb/ka05w00000123rv-00N5w00000Ri7BU-0EM5w000005vPMB.png?fit=max&auto=format&n=wsUUuFj2iQGL8oiS&q=85&s=3764467796aed334a118a16375171ff7" width="2832" height="858" data-path="images/kb/ka05w00000123rv-00N5w00000Ri7BU-0EM5w000005vPMB.png" />
     </Frame>

   * For older versions of Workbench 5.

     <Frame>
       <img alt="2.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/wsUUuFj2iQGL8oiS/images/kb/ka05w00000123rv-00N5w00000Ri7BU-0EM5w000005vPM9.png?fit=max&auto=format&n=wsUUuFj2iQGL8oiS&q=85&s=4a6579f3b29eec09a533ebcf413eefd9" width="2802" height="734" data-path="images/kb/ka05w00000123rv-00N5w00000Ri7BU-0EM5w000005vPM9.png" />
     </Frame>

     <Frame>
       <img alt="3.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/wsUUuFj2iQGL8oiS/images/kb/ka05w00000123rv-00N5w00000Ri7BU-0EM5w000005vPMA.png?fit=max&auto=format&n=wsUUuFj2iQGL8oiS&q=85&s=a7cce017b735f8bff7550aefcec3e8fd" style={{width: 428, height: 188}} width="2136" height="940" data-path="images/kb/ka05w00000123rv-00N5w00000Ri7BU-0EM5w000005vPMA.png" />
     </Frame>

2. Update the job to Replace.

   In the Configure Tab, change the Update method to **Replace**.

   <Frame>
     <img alt="4.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/wsUUuFj2iQGL8oiS/images/kb/ka05w00000123rv-00N5w00000Ri7BU-0EM5w000005vPMC.png?fit=max&auto=format&n=wsUUuFj2iQGL8oiS&q=85&s=9e4d86f32203f72116ea9de18f465749" width="1780" height="868" data-path="images/kb/ka05w00000123rv-00N5w00000Ri7BU-0EM5w000005vPMC.png" />
   </Frame>

3. Run the job.

   Once the DataSet has been updated to Replace, run the job.

4. Re-protecting Columns

   To protect columns from future changes:

   * For newer versions of Workbench 5: Re-protect the columns in the Schema tab and update the Schema Update options to your desired preferences.
   * For older versions of Workbench 5: Uncheck
     **Allow changes**.
