Import data from Excel into source table doesn't refresh while load in to target table

[Matt25]

1. Import data from Excel to source table (Oracle) using Alteryx output tool

2. Reopen the same workflow to read source table using the input tool

3. Load data into a target table in ORACLE

I am facing issue where Alteryx doesn't refresh the data while reading from the source table after importing ( In Same workflow).

[Warcry]

Use control containers tool:

1. Container 1: you ELT/ETL in oracle

2. Container 2: Run PLSQL 

3. Container 3: Load data in oracle

[Warcry]

If this solves your problem, please hit the thumbs up button.

[KGT]

One of the core elements that needs to be considered in this and the use of control containers by @Warcry solves for, is that when you hit run on an alteryx workflow, all input tools will be initialised and start to be read. So, the only way that you will be able to write an output and then read that back in, is by delaying that initial read. Either through use of control containers, batch macro, dynamic input or similar.

There is not much to describe the reason for doing the process in the order you are, but you may want to look at the In-DB tools for part of it if you are doing more than just Import/Export.

[Warcry · Accepted solution]

If this solved your inquiry, please accept my solution as solved.