Macro - to run 30 days data

[kobetse]

Hi folks,

I'm new to using macro in the workflow..appreciate if anyone could help..

I have following problems,

I'm doing a monthly report - to analysis some sales data

Given that there are 30- days sales data with different date, what i need to do is to analysis them then group 30-days data into a table

Expected outcome like below,

Date	Branch (code)	Item	Selling Price	Sold Qty
8/11/2023	100A	Apple	2.5	10
8/11/2023	100B	Orange	1.7	15
8/11/2023	100C	Kiwi	1.7	10
8/11/2023	100D	Blueberries	3.2	5
8/12/2023	100A	Apple	2	15
8/12/2023	100B	Orange	1.5	12
8/12/2023	100C	Kiwi	1.5	10
8/12/2023	100D	Blueberries	3.5	8
8/13/2023	100A	Apple	2.3	17
8/13/2023	100B	Orange	1.8	12
8/13/2023	100C	Kiwi	1.8	13
8/13/2023	100D	Blueberries	3.5	6
8/14/2023	100A	Apple	2.3	11
8/14/2023	100B	Orange	1.7	8
8/14/2023	100C	Kiwi	1.9	5
8/14/2023	100D	Blueberries	3.3	7
8/15/2023	100A	Apple	2.5	8
8/15/2023	100B	Orange	2.5	16
8/15/2023	100C	Kiwi	2.3	9
8/15/2023	100D	Blueberries	3.5	3
8/16/2023	100A	Apple	2.3	8
8/16/2023	100B	Orange	2.4	6
8/16/2023	100C	Kiwi	2.6	7
8/16/2023	100D	Blueberries	3.7	7
8/17/2023	100A	Apple	1.7	7
8/17/2023	100B	Orange	1.7	7
8/17/2023	100C	Kiwi	2.3	6
8/17/2023	100D	Blueberries	3.3	6

*Selling price is not fixed, it will change daily

What I have in mind is to create a macro -> to run the workflow like 30 times automatically 
then use union tools to group 30-days output file to create the table

My question is

given 30 files are having different dates, items are having different selling price 
does it mean i need to manually input the file and run it one by one? Or i could apply macro in this case?

If so, can anyone pls advise how to write it?

(*I had already created the workflow which's for analyzing the data (1st step) )

Thank you

[binu_acs]

@kobetse use the batch macro or dynamic input tool to combine all the files into one for your analysis. The below post might be helpful for your use case

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/The-Ultimate-Input-Data-Flo...

https://community.alteryx.com/t5/Community-Gallery/Read-All-Excel-Files/ta-p/897750