Current Date + last 6 days data to combine

[Dhruv_001]

Hi everyone,

I've looked around the community for an Alteryx solution but can't seem to find one - so posting it! 

Basically, I have data coming from three tables. I have joined the data and my dataset it complete now.

The next step I want to make it dynamically is that to run transformation on current date and pull the last 6 days and perform transformation and save in excel file. Then the next current date comes and pull the last 6 six dates and same step follow.

For example : I pass 18th Sep current date, i want my workflow to do transformation on 18th Sep and pull last 6 days data (17th,16th,15th,14th,13th,12th Sep) and perform transformation and save results.

Next again it takes 19th Sep current date and pull last 6 day

s (18th,17th,16th,15th,14th,13th Sep) data and do transformation and save the results in the existing file.

I want this step to be repeated for all my historical data.

Thanks in advance. 

I've looked around the community for an Alteryx solution but can't seem to find one - so posting it! 

. 

Example : 19/02/2020 current date is passed, I want my workflow to pull last 6 dates along with it and perform transformation.

Next 20/02/2020 current date is passed  I want my workflow to pull last 6 dates along with it and perform transformation.

But I need it dynamically to be done.

Input:

Transaction Date	Balance
25/01/2020	1
26/01/2020	2
27/01/2020	3.9
28/01/2020	4.2
29/01/2020	5.0
30/01/2020	6.5
01/02/2020	100
02/02/2020	8999
03/02/2020	922
04/02/2020	101
05/02/2020	112
06/02/2020	23
07/02/2020	21
17/02/2020	89
18/02/2020	76
19/02/2020	0

[binuacs]

@Dhruv_001 One way of doing this

[Dhruv_001]

Is it possible to tweak this workflow?

Instead of pulling the daily file through sql. I want to run for historical data. Workflow should run for each date and according to that sql should that file of date from different tables.

for example, 17th sep is the date the workflow will run and pull the last 6 days data from sql table along with it.

[Dhruv_001]

Is it possible to built a batch macro, to read single file by file from SQL server.

First file_name is picked and do transformation.

So picking up the current date and last 30 days data