How to update/Insert the excel output

[ankurrjit]

I am running a straight workflow from oracle to an excel file. Now I am trying to set up an update/insert strategy based on a calculated field "First Used Date". So if the product coming from Oracle is new then it should insert in the excel sheet with the field "First Used Date" as run date, if the Product is already present in the last generated excel sheet then it should not update the field "First Used Date".

Alteryx Designer V - 2019.3.6.20285

[AbhilashR · Accepted solution]

Hi @ankurrjit, attached is a solution that I think might address your ask. The tool Oracle Source in my case is a static list, but it'll be the Oracle Input connection in your case. Basically the workflow brings in Oracle connection data + existing excel file and uses the Join tool to reconcile the two datasets. Anything that is new (i.e. not available in excel) comes out of the L output of the Join tool, to which we add a formula to introduce datetimetoday(), and it is written back to the file you read. Given the approach reads and writes back to the same excel file, you will need to use the Block Until Done tool to ensure I/O operations on the excel are not concurrently happening. 

I built my solution using v2020.1 but it should work on your version too.

[ankurrjit]

Thanks, @AbhilashR. Seems I am not able to open it in my version as it is giving me an error.

This workflow was created by a more recent version of Alteryx and may contain tools or functionality not present in this version. Alteryx does not support using an earlier version of Alteryx to open a workflow created with a newer version. For best results, download the latest version of Alteryx.

Is there any other way to open it in a lower version, if not can you please share the snapshot of each step so that I can try at my end.

[AbhilashR · Accepted solution]

Hi @ankurrjit, follow the steps mentioned in this Community page to adjust the Alteryx file for different versions: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Adjusting-Alteryx-Files-for-Differe...