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

[Kinetic_analytics]

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

[Robin_McIntosh]

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

[Kinetic_analytics]

Yes.

[IraWatt · Accepted solution]

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