I'm using the Dynamic Input tool to import the latest excel file in a folder. The excel data does not have when the data is pulled. Is there a way to get the Creation Time as it's own column so I can have a Data As Of field?
Solved! Go to Solution.
The output from a DIRECTORY tool will provide Creation Time, LastWrite Time as variables. If you output the filename as part of your input tool, you can join to this information.
Cheers,
Mark
Hi Mark,
Thanks for quick response. Sorry I'm fairly new to Alteryx and could not follow your instructions. I'm already using the Directory tool and using the Creation Time to point to which file I want to Dynamically input. Could walk me through this solution in more detail?
Katie
Well that was quick! I took the output from the SAMPLE and placed a select on it (changed creationtime from datetime to just date). That select then was connected to an APPEND FIELDS tool where the top (target) data had the CreationTime (Source) appended to every record.
That was what was needed......
Cheers,
Mark
Thanks again for your speedy help!