Append daily files to create YTD File
- 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
Hello all,
I have a requirement where i will receive daily files from a source. What i need to do is to append all the daily files and create a YTD file before i could process them further. On some days, due to various reasons, i might not receive the file. On those days i should not duplicate the rows with the existing daily files. I have to schedule the workflow to avoid manual intervention.
Please suggest some ideas on how to achieve this in alteryx.
Thanks!
Solved! Go to Solution.
- Labels:
- Best Practices
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If all of your files are the same layout, look at the first example under the Dynamic Input tool. It uses the Directory tool and the Dynamic Input tool.
If some files may have different columns, try this knowledge base article:
The Ultimate Input Data Flowchart
Community > Designer > Designer Knowledge > The Ultimate Input Data Flowchart
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...
Chris
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @ChrisTX. All the files will have same layout. I will look into the example.
