Updating the existing workflow with new data every month

Hi Team,

I need help.

I have three months of dataset in the sql server. I connect to sql server and i create a new column for the calculated average of all the three months by Place in the alteryx workflow. Please find below the sample data

Now the problem is i will be getting the new data every month and i need to append to this data and calculate the average. I dont want to manually import new data every month and run the workflow.

Please let me know if any automated flow is avaliable,

Thanks,

Sri

Datasets

Dynamic Processing

Data Investigation

Scheduler

Accepted answers

Ladarthure

I did a sample using your screenshot!

sample_com.yxmd

messi007

@sriniprad08,

Please see below how you can do it

Attached the worklfow,

Regards,

AVG_20210928.yxmd

All comments

Ladarthure

Hi @sriniprad08,

the solution would be to my mind to use a transpose tool and then calculate the average. In the end, you can also use a cross tab if you want a specific format or even use a join to join the new averages calculated with a summarize.

messi007

@sriniprad08,

Could you share a sample data? It will help us to give you the solution.

Regards,

sriniprad08

Hi @messi007

Please find attached the data and the intended output. Every month new data will be uploaded.

Need to calculate the average by place by month.

output

thanks for the help

sample_alt.xlsx

sriniprad08

Thank you @Ladarthure

Ladarthure

I did a sample using your screenshot!

sample_com.yxmd

sriniprad08

Thank you very much @Ladarthure helpful. However i have question suppose every month new excel data is uploaded how to append that to the existing master file and add a date column to make sure it correctly map the place.?

Ladarthure

Yes, you can try and replace the text input I did with an excel file, add 2 columns an it will work as intended. The trick is in the use of the *Unknown field in the Transpose tool and a record Id for regrouping the data all together!

sriniprad08

@Ladarthure something simliar to the below format output please. I need to create a new month and year column

messi007

@sriniprad08,

Please see below how you can do it

Attached the worklfow,

Regards,

AVG_20210928.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703