Append daily files to create YTD File

[Balajiprasad]

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!

[ChrisTX · Accepted solution]

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

[Balajiprasad]

Thanks @ChrisTX. All the files will have same layout. I will look into the example.