Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Grabbing multiple files depending on the day of run

jillv
7 - Meteor

Hi

 

Hoping someone could help advise on how to solve this in Alteryx.

 

I have multiple files received on a daily basis:

 

every Saturday - Weekly full (which is a catch all file)

from Mon-Thurs - daily delta file (anything that is newly added and had changes)

Sat - Weekly full   Mon - Daily - Delta   Tues - Daily - Delta   Wed - Daily - Delta   Thurs - Daily - Delta  
Record IDTypeRate Record IDTypeRate Record IDTypeRate Record IDTypeRate Record IDTypeRate
1EQ1.3 1EQ3.4 10FI3.4 2FI3.3 11CS2.3
2EQ5.3 2FI5.3 11CS5.3 11CS3.3 13FT1.4
3EQ2 8CS3.5 12EQ7.3 13FT4.4 14FI5.5
4FI3.7 9FT3.3 9FI3.3     15EQ3.5
5CS4                
6EQ3.5                
7FI2.4                

 

The ask is depending on the day I run the workflow will grab the latest Saturday weekly file + the daily delta file.

and if the same record ID appeared in the delta file, I just need whatever the latest data for that record ID

 

e.g. 

If I run the workflow on Sat, Sun, Monday --- pull the latest Sat weekly file

If I run the workflow on Tues --- pull the latest Sat weekly file + latest Mon file

If I run the workflow on Wed--- pull the latest Sat weekly file + latest Mon file + latest Tues file

If I run the workflow on Thurs --- pull the latest Sat weekly file + latest Mon file + latest Tues file + latest Wed file

If I run the workflow on Fri --- pull the latest Sat weekly file + latest Mon file + latest Tues file + latest Wed file + latest Thurs file

 

jillv_0-1676563104264.png

 

 

Thank you! Any advice is highly appreciated. 

2 REPLIES 2
Yoshiro_Fujimori
15 - Aurora

@jillv ,

I guess the files have names with the creation date. If not, please consider to do so.

Then you save all the files in the week in one folder and create the workflow:

 

1. read all files in the folder at once, with the filename added to the table.

2. parse the date from the filename field.

3. sort the table with Record ID and File Date (Desending order).

4. pick the first row of each Record ID.

 

Intput Data tool configuration

Yoshiro_Fujimori_1-1678095644191.png

Workflow

Yoshiro_Fujimori_0-1678095308959.png

I am not sure if this can be the exact solution for you, but I hope this may be helpful.

Good luck.

Kamran1991
11 - Bolide

Hi @jillv 

 

Can you please share a dummy sample data ?

Labels