"Output File Name as Field" option for Dynamic Input
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks again for your speedy help!
