Directory Input, LastWriteTime - show in final output after macro's dynamic input

Hello everyone,

I have a workflow which utilises the Directory Input tool. This identifies a list of files in a file directory. I have a batch macro for bringing in multiple tabs from multiple spreadsheets. Once a specific template matches, the subsequent workflow steps are applied.

The output works, however I would like to bring forward the file's LastWriteTime in the final output. I cannot seem to link the Directory Input's LastWriteTime to the workflow on the other side of the batch macro. How can I do this?

I have attached a screenshot of my workflow, but if you need further information, please let me know.

Directory Input Screenshot.PNG

Workflow

Datasets

Developer

Input

Output

Macros

Batch Macro

Accepted answers

messi007

@RichardJH,

On the batch macro you can add the file name as a field:

And based on that you can do a join with the output directory and the lastWriteTime.

Hope this helps!

Regards

All comments

Ladarthure

Hi @RichardJH,

one way to do this would be to do a join on filename (or fullpath) that you can set to have while reading the file from the batch macro to the the data after you read the directories and unioned those.

tell me if it is unclear so that I can help you!

messi007

@RichardJH,

On the batch macro you can add the file name as a field:

And based on that you can do a join with the output directory and the lastWriteTime.

Hope this helps!

Regards

RichardJH

Thank you both @lardarthure and @messi007. I have applied a join and amended the workflow to get the desired result. Thank you both for your help.

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335