Open Multiple Files, Append CreationTime as a Field

[jwilds1]

Could use some assistance. I have a need to perform the following and am unclear how to pursue it.

1) Import data from one of multiple Excel files (for discussion, we'll call this first file "File 1").

2) Append the CreationTime of File 1 to every record in the Table from File 1.

3) Import data from File 2

4) Append the CreationTime of File 2 to every record in the Table from File 2.

5) Aggregate ALL of the data together for as many files that match the wildcard

----------------

I've tried this in the attached file using the Dir tool and a Dynamic Input, but the Append tool appends each & every CreationTime, not just the specific one for that file.  

I have a feeling this will require a macro, but I'm a complete novice with Alteryx - any and all training I've had has been through trial and error.

[mathieuf · Accepted solution]

Hi @jwilds1,

What about this?

Join using the filename. Be sure to check the FileName option in the dynamic input

[jwilds1]

Thank you - that worked. It never occurred to me to pass the filename in the Dynamic Input.

[Emma3]

From a happy person in 2024, thank you both! This was just what I needed to figure out how to add CreationTime into my workflow's input files. (I have input files that will be overwritten every 2 weeks.) Thanks for asking the question in a way I could find it @jwilds1 and for answering with an example @mathieuf. Much appreciated.