Taking File Name and Appending it to the Data when importing with the directory tool
- 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
Hi,
I have a directory of names that goes from 1880-2021. Each file in the directory is one year. However, that year is not contained in the file as data and is only the file name. I would like to import the files and append the file name to each of the rows that it belongs to. I have attached the packaged workflow and if the directory tool cannot provide the files you can obtain them here: https://www.ssa.gov/oact/babynames/limits.html and click on the National Data link to download the files.
Any help here would be great.
Solved! Go to Solution.
- Labels:
- Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @Link86,
The dynamic input tool has a configuration setting to import file name as a column of data here:
Does this solve your issue?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@IraWatt Thank you. I can't believe I missed that.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
haha now worries @Link86 happens to us all 😄