Easiest way to grab all files in a directory, add the creation date and union

[Carluccio555]

Having trouble getting dynamic input and directory tool to work together.

What I need to do: grab all files in a directory, add the creation data as a field (excluding time) and then union everything

thanks

[binuacs · Accepted solution]

@Carluccio555 use batch macro https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

[cjaneczko]

Are all of the files in the same format? Take a look at this post. I use this batch macro in conjunction with the directory tool to pull ALL files in a folder. The Directory tool will generate a field with the Creation date.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Input-Batch-Macro-AKA-the-Extr...

[Carluccio555]

Files will all be xlsx, can this be done without a batch macro?

[binuacs]

@Carluccio555 If  your files are in different schema then the only option is the batch macro

[Carluccio555]

OK Ive got the batch macro working to union the files, heres the macro, how do I add the creation time, directory tool is on deck

[Carluccio555 · Accepted solution]

Directory tool>Select>formula.  So I guess I have to join this using the file name in the control paramter?

[cjaneczko]

Yes, you would join the Directory tool to your Batch Macro output and link it via the File name or Full Path, whichever field comes out of the macro. Then only bring over the Creation Date from the Directory tool.

[cjaneczko]

On a side note to plan ahead, in the event one of the files is open while the batch macro is running, you can insert the below to skip that opened file. It will save you a headache. Anchors highlighted in Red are from the same input (directory tool) with the Join on FileName.