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

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

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703