Alteryx Dynamic Date input.

Question

Hello All,

I want to schedule the job to run  for every Tuesday to calculate the sum of sales for a store till(before day) i.e, Monday.

While job runs every Tuesday it should append the store sales like shown in the output in the Alteryx DB history.

FYI  refer the attached input and output.

Appreciate your help on this.

Thank you.

Sales_example.xlsx

Qiu · Answer

@Sravya9395 
Similar thought with @Yoshiro_Fujimori 
We can use the yxdb to store the "old" data and Union with the new one as below.

0507-Sravya9395.yxzp

Yoshiro_Fujimori · Answer

Well if you run the job weekly, I would keep the output from the last week's job and append the output from this week's job.

Like below.

Workflow

1269898_2.yxmd

Sravya9395 · Answer

Thanks for the reply, Yoshiro.

Table 1 should have the future dates too.

It is not limited to the input in the excel, it is just an sample data for a small period..

Indeed this should be applicable for future dates too.

Like on 21st May( Tuesday) , it should run till 20 th May ( Monday).

So this data range should be based on the current date.

Some thing like dynamically inputting the value.

Let me know if you have any additional questions.