The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Macro - to run 30 days data

kobetse
5 - Atom

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,

 

DateBranch (code)ItemSelling PriceSold Qty
8/11/2023100AApple2.510
8/11/2023100BOrange1.715
8/11/2023100CKiwi1.710
8/11/2023100DBlueberries3.25
8/12/2023100AApple215
8/12/2023100BOrange1.512
8/12/2023100CKiwi1.510
8/12/2023100DBlueberries3.58
8/13/2023100AApple2.317
8/13/2023100BOrange1.812
8/13/2023100CKiwi1.813
8/13/2023100DBlueberries3.56
8/14/2023100AApple2.311
8/14/2023100BOrange1.78
8/14/2023100CKiwi1.95
8/14/2023100DBlueberries3.37
8/15/2023100AApple2.58
8/15/2023100BOrange2.516
8/15/2023100CKiwi2.39
8/15/2023100DBlueberries3.53
8/16/2023100AApple2.38
8/16/2023100BOrange2.46
8/16/2023100CKiwi2.67
8/16/2023100DBlueberries3.77
8/17/2023100AApple1.77
8/17/2023100BOrange1.77
8/17/2023100CKiwi2.36
8/17/2023100DBlueberries3.36

 

*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

1 REPLY 1
binuacs
21 - Polaris

@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

 

Labels
Top Solution Authors