Grab files depending on the day

[jillv]

Hi,

Hoping someone could help solve this.

I have different files received on a daily basis:

weekly file received on Saturday

delta files received on Monday to Thursday

Saturday Weekly full				Delta - Monday file				Delta - Tues file				Delta - Wed file				Delta - Thurs file
Record	Type	Rate		Record	Type	Rate		Record	Type	Rate		Record	Type	Rate		Record	Type	Rate
1	EQ	1.3		7	MF	9		9	EQ	1.1		1	EQ	1.3		6	EQ	4.5
2	EQ	2.4		8	EQ	3.1		10	FT	1.5		2	EQ	2.4		7	MF	9.1
3	EQ	4		1	EQ	1.5		7	MF	9.2		11	FT	2.1		12	EQ	2.1
4	FI	5										9	EQ	1.2		13	FT	1
5	FI	4.3										10	EQ	1.5
6	EQ	4.2
7	MF	9

-- Depending on the day I run the workflow, it will pull the weekly file OR weekly file + the delta files of the prior days

e.g

if I run on Saturday, Sunday or Monday - it will pull the just the Sat weekly file

if I run on Tuesday - it will pull the weekly file + delta Mon file

if I run on Wednesday - it will pull the weekly file + delta Mon file + delta Tues file

if I run on Thursday - it will pull the weekly file + delta Mon file + delta Tues file + delta Wed file

if I run on Friday - it will pull the weekly file + delta Mon file + delta Tues file + delta Wed file + Thurs file

then if the same record id appeared in the delta files, get the latest value from the latest delta file 

Thank you! Really appreciate any guidance on this scenario. :)

[caltang]

Can we have some raw data please? Or does the data come in those tables affixed to an Excel sheet?

Regarding the selections depending on Day, I think it will be easier for us to create an interface for you to select the days you want on the days you open Alteryx rather than limiting it to certain days. 

If you must insist on having it for certain days, you can leverage the DateTimeToday(), and if it matches your date, filter on those dates that correspond to your conditions.

[caltang]

By the way, just to confirm, are the table names fixed? 

Saturday Weekly full

Delta - Monday file

Delta - Tues file

Delta - Wed file

Delta - Thurs file

Record

Type

Rate

Record

Type

Rate

Record

Type

Rate

Record

Type

Rate

Record

Type

Rate

[Raj]

Can you share the file names how it is created and what is the format so understanding that we can create logic.

you said you get files daily.right?

otherwise, it is difficult to understand the requirement.