We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Order items ran (I want to export an excel then import from that same directory)

wonka1234
10 - Fireball

Hi,

 

I have a workflow that 1) Exports an Excel (This week excel ) and 2) Imports Previous Weeks Excel.  

 

How can I ensure that my 1) is exported before I import my previous week. I dont want to export then import the same file.

 

Ie.  Export  File_20240204.xlsx. 

 

and I want to import File_20240121.xlsx. 

 

My directory tool to import 2) reads all the files in the directory , sorts by latest created, and skips the 1st file to read in the 2nd (which i want it to be to import the previous week).

 

How can I do this/ensure that 1) is exported first before i import my 2nd file?

1 REPLY 1
aatalai
15 - Aurora

try block until done tool;from the 1 output set the steps needed to complete process 1 and then the steps for process 2. Let me know if that helps

Labels
Top Solution Authors