Error: Output Data (603): You must specify a file name.

Hello:

I hope you all are doing great. I am facing an error. Which is : Error: Output Data (603): You must specify a file name.

I have used this:

I am trying to get multiple tabs output in an excel output. How can I fix this error? Appreciate your solution.

Thanks

Workflow

Accepted answers

IraWatt

Hey @Kinetic_analytics you could try using @DataNath's Output to multiple Excel files or sheets - Alteryx Community Macro on the gallery if you want to keep it simple.

All comments

Robin_McIntosh

Is your path complete including sheet name(s) if Excel?

Kinetic_analytics

Yes.

IraWatt

Hey @Kinetic_analytics you could try using @DataNath's Output to multiple Excel files or sheets - Alteryx Community Macro on the gallery if you want to keep it simple.

Kinetic_analytics

Appreciate your help. I actually want the output files in multiple tabs, which is possible in using output tool. Thanks

IraWatt

@Kinetic_analytics, this is true but the macro unlike the output tool removes the need to add all the things that can cause formatting errors like the one you have. Would you be able to share an example file path you are using?

DataNath

Thanks for the plug @IraWatt - appreciate that! And quite right - the macro allows you to select multiple files or multiple sheets as outputs so you have both options!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335