Extract data on the basis of Date Range

[RaghavanR]

Hi,

I have a requirement that I have some data in a file by date (Sample data 1.xlsx). In another file, I have the date master (Week Master Orignal.xlsx). All I need is to get the data in the first file summarized on the basis of date range in Date master (Amount column in Weekl Master Original.xlsx is the result i am trying to bring in Alteryx)

Not sure how to do this. Can you please help me by guiding how to do it in Alteryx?

Sample files are attached.

[RaghavanR · Accepted solution]

I found a solution in the below link. Thanks

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-Join-on-a-Date-Range/ta-p/29...