Need help using Output Data tool to export Alteryx file into Excel file

[Jack5]

Hi all,

I need some assistance in using the Output Data tool in my Alteryx file to export it into an Excel (xls) file. Per my instructions:

"a. Use the Output Data tool to export the data to a Microsoft Excel file .xls
b. Name your file HMC Clean Data_Group41 and insert your group’s number
c. If Alteryx asks you for a sheet name you can call it Clean Data.

I've attached my file to this post. My Output Data tool is at the end of my workflow but has an error message. It says I have no table selected. I'm exporting a rather large dataset and just want to make sure the whole dataset is exported with all the changes I have made. Any help would be greatly appreciated.

[AkimasaKajitani · Accepted solution]

Hi @Jack5 

You have to add the sheet name of excel file at Output Data tool.

FileName : 

HMC Cleaned Data_Group41.xls|||sheet1

If you click the red circle of the below screenshot and choose the save file, it would be  automatically work well.