Pulling in the Newest File and Point to a Specific Tab Using Directory Input

Question

Hello!

I am pulling in the newest file every time run the workflow. All of the inputs point to the same file, but I have pointed each input to a different tab using the formula tool. I then union them. This solution works great but would like to make this workflow more efficient.

Is there a way I can do this using a macro? I feel like it is fairly bulky and would like to streamline as much as possible.

Bridget Hutter

Luke_C · Accepted Answer

Hi @bridgethutter

You could simplify by re-shuffling the order of the tools:

* One directory tool
* Sort, filter and sample
* Then branch out to the three tabs

Christina_H · Accepted Answer

Based on your workflow, you're getting the same format of data from each tab?  How about something like this?

bridgethutter · Accepted Answer

Hey! Both solutions worked. I was just interested in learning how to update something through a macro.

Thanks!

Bridget