Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Open Multiple Files, Append CreationTime as a Field

jwilds1
5 - Atom

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.

2 REPLIES 2
mathieuf
Alteryx
Alteryx

Hi @jwilds1,

 

What about this?

 

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

mathieuf_0-1638542511132.png

 

jwilds1
5 - Atom

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

Labels