Create table with different horizon as per supplier from Alteryx

[arsh011]

I want to create tables for different suppliers according to their given horizon, if the horizon period is same or fixed for every supplier then its achievable through formula but there are different horizon periods for differnt different suppliers like 12 months for suppliers and 18 , 8 months for some. How i can do this in alteryx that the table creates for each supplier is automatically generate as per their horizon period.

i create a formula to do this but itakes only max horizon values for all suppliers. Please help !!!

[Qiu]

@arsh011 
It should be something like below?

[arsh011]

thanks @Qiu  mate but the idea is to create the horizon in different excel files as per supplier like for supplier A file with 12 months

and supplier D file with 8 months , separate files not in a single excel file.

[arsh011]

Hi @Qiu  mate , I want to create a iterative macro for writing files in Excel as per their horizon , please help and could you or anyone in the community provide the macro tutorials so I can understand concept behind macros in alteryx and learn how to create macros in alteryx .. Please Help !!! 

[TheOC]

hey @arsh011 

Please find below:
Standard Macros -
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Standard-Macro...
Iterative Macros -
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Iterative-Macr...

Thanks,
TheOC