As per business requirement, daily I'll be receiving 6 excel files (1.xlsx, 2 .csv and 3 .xls) from 6 different sources on my email. The challenge here is that the receiving timing of the files is not fixed. Each day file receiving time varies. Hence, I would keep checking the mailbox and whenever the files are received I'd save them down to a particular path.
I wanted to create a single workflow where alteryx will import available excel files, process them and give output whenever I run the workflow. Later when I add new excel files to the path and re-run the workflow, it must only process newly added files and give output.
However, I would also want an option where I can specify if I only want alteryx to process newly added files or process some of the processed file and some of the unprocessed file or all of them. (This is just so that if someday any of the received files was incorrect and later on the same day I receive a revised file, so alteryx must not skip processing it.)
Note: Attached, are few sample files downloaded from google. Hence, data will not be relevant to what I would be receiving and processing.
