Outputting to files - May not have data for a year, so no file needed

[TeamTJ]

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

[mborriero · Accepted 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.

[TeamTJ]

That works perfectly, thank you very much!

Morgan