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?
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