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

Sorting Workflow.yxmd

Sorting Query - Alteryx .xlsx

Output

Accepted answers

AngelosPachis

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

AngelosPachis

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

All comments

AngelosPachis

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!!

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

Sample - Output Forwards.xlsx

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703