Start Free Trial

Alteryx Designer Desktop Discussions

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

Adding Macro to pick new file

kauser
8 - Asteroid

Hello, 

 i am working in a workflow where business need to add new file (e.g. loan or funding) depends on the client. how can i build a Macro to pick those new upcoming file so Alteryx can pick those new files without modify and/or update existing workflow. 

 

Thank you 

 

kauser 

1 REPLY 1
EKasminsky
9 - Comet

I mean what comes to mind is doing using a directory tool, then sort by create date/last updated date, then select records tool (set as 1) to get the most recent file. 

From there, I would use a formula tool to pull the full file path, and the "Batch import multiple files" macro I found in the Gallery.

 

Basically, it sounds like you want to pull the most recent file to determine what to do with it, and that's how I would do it.

Labels
Top Solution Authors