How to input monthly file automatically in Alteryx?

anhnguyenngoc2002

Hi everyone,

I'm doing monthly report. I have folder of each month, every folder contains same 2 file inputs like below.

I have built workflow to calculate necessary result for monthly report.

What I want to do is that when I input a month, for e.x April 2022 and I aslo want to calculate following 3 months report, it will give me the reporting of 4 months April, May, June and July. Each result of each month will be output to its folder.

I have attach needed input to clear my problem. I think I will have to use Macros in Alteryx but have no idea about this. Please help me with this.

Thank you very much.

Example.yxmd

Sales.csv

Unit Price.csv

Workflow

Reporting

Output

Accepted answers

geraldo

@anhnguyenngoc2002

Following your workflow I made an adjustment to exemplify the use of the macro.
In the workflow you are already creating the dates. I put a formula to format the date to "Jan 2023" and created a macro to receive some data.
Make the necessary adjustments for the calculations, I believe that with a few adjustments you will achieve your goals

my Alteryx version is 2022.1 if yours is lower you have to edit the macro first and save

WorkFlowExample.yxzp

binu_acs

@anhnguyenngoc2002 You can convert your workflow into the App and select the month you want to run the report

And if you sect the April 2022 the macro will generate next 3 months report as well and save in the respective folders

Example (5).yxzp

All comments

geraldo

@anhnguyenngoc2002

I would like to know how you are thinking about parameterizing this flow of yours.
how do you inform the month to be processed and also the number of months you want to process. The way you are thinking. the way it is, it's hardcoded for input and output files.

anhnguyenngoc2002

Hi @geraldo

My first idea is that I will input start month and number of months I want to calculate. Then it will automatically generate that month, maybe using Row Generate Tool (?). These month will be replaced in the path folder input/ouput. The calculation process I have already done, I think I gonna use macro for this process. Yep, my problem now is still the input and output.