I am brand new to Alteryx as of yesterday.
I have some data that I run through some filters then need to spit out that filtered data to Excel with each year's data on a different tab.
I know how to do this using nested filters:
First Filter True = Write that data to specific tab
First Filter False = Go to Second Filter
Second Filter True = Write that data to specific tab
Second Filter False = Go to Third Filter
Third Filter True = Write that data to specific tab
Third Filter False = Go to Fourth Filter
The problem is I currently have years going back to 2002, but may not have some years in-between and I don't want to make 16 filters and add a new one each year.
Is there a way to do something like this:
For Each Year in my data
Output Data to the output file, tab named after the year
Next Year
Thanks!
Morgan
Solved! Go to Solution.
Hi @TeamTJ, if you use the output tool, writing an excel file, there is a option that allow you to change tab based on one of your column.
See the workflow attached.
Hope it helps.
That works perfectly, thank you very much!
Morgan