I was trying to use the 'update dataset in a table chain template' (https://support.workiva.com/hc/en-us/articles/360058919852-Update-Datasets-in-a-Table-chain-template) to update/overwrite my dataset imported to a table. My chain looks like this, similar to https://support.workiva.com/hc/en-us/articles/360050552311-Extract-Data-from-Oracle-Hyperion-Financial-Management-to-Workiva-as-a-File.
Here shows my setting for the 'Run Chain' command, I renamed the chain template 'Update HFM Extracts' and selected 'Replace dataset' in the Replace frequency field.
The 'Update HFM Extracts' chain looks like this (no major change from the template) and below shows the 'Runtime inputs' setting for the 'Replace frequency' input.
Here shows the setting for the 'Create File' command:
My problem is that although the chain was successfully executed, instead of updating the table, it kept adding new entries into the table (i.e. appending). What should I do to fix this?