Output in seperate excel sheets

[anitamarie2020]

Hi All, 

I'm trying to sort the data into excel sheets based on Fund name (Fund 1, Fund 2 etc), I keep getting 'Must specify sheet name' error message, 

I've tried to update but i'm still getting the same message,

Any help would be much appreciated 

Thanks,

Anita 

[AngelosPachis · Accepted solution]

Hi @anitamarie2020 ,

The issue here is that your Fund column contains some Null values towards the bottom of your table

You can see that using the Browse tool. If you remove those nulls with a filter tool, then the output data tool should work as expected, creating a different tab for each fund.

Hope that helps,

Angelos

[anitamarie2020]

Thank you so so much!! That worked 🙂 

I won't even tell you how long I spent trying to figure that out!!

[AngelosPachis]

No worries @anitamarie2020 ,

That was tricky because probably the rows would not be visible if you don't add a browse tool in there.

Happy that I was able to help and well done for configuring this output tool correctly!

Cheers,

Angelos

[anitamarie2020]

Sorry Angelos - 

When I ran the output it seemed to be fine 

But when I clicked into the output file there was only this information in it 

[AngelosPachis · Accepted solution]

Hi @anitamarie2020 ,

In the configuration window of your output tool, can you try changing option 3 from "Overwrite File" to "Overwrite Sheet" instead?

I believe the issue is that with the current configuration, every time Alteryx finds a new Fund number it creates a new file, so when Fund 99 is reached (which is the last value in the Fund column) the file is replaced and only this sheet is kept.

However, changing that to Overwrite Sheet will only replace the corresponding sheet, and not the whole file.

Hopefully that makes sense, please let me know if that worked for you.

Regards,

Angelos