Dynamically output to different sheet names based on a field?

[AkisM]

I want to output data to a pre-formatted excel, but certain rows go to different sheets. There are 50+ sheets so I don't want to make 50 streams with 50 outputs. Is there a way that I can choose sheet name based on a column that I will populate with formulas?

[fmvizcaino · Accepted solution]

Hi @AkisM ,

Yes, there is a way!

You can configure the sheet name and take it from a column using the below configuration of the output data tool.

Best,

Fernando Vizcaino

[Krish_Penubarthi]

I tried like you suggested, but I did not get the answer I was looking for. Please check the attached workflow.