Current Date + last 6 days data to combine

Question

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 DateBalance25/01/2020126/01/2020227/01/20203.928/01/20204.229/01/20205.030/01/20206.501/02/202010002/02/2020899903/02/202092204/02/202010105/02/202011206/02/20202307/02/20202117/02/20208918/02/20207619/02/20200

Dhruv_001 · Answer

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

Dhruv_001 · Answer

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.

binu_acs · Answer

@Dhruv_001 One way of doing this

Date_190923.yxwz