Output to a table in Excel from Alteryx

[asuamat]

Hi,

I'd like to print the output of an Alteryx workflow into a table in Excel. I am creating an empty table in Excel and then inserting the name of that table to the file path on the Output Tool so that Alteryx knows where to output to (much like using the name of a Named Range to direct Alteryx to output there). However, when I run the workflow and open the Excel file, the table is still not populated and appears empty.

Is it possible to output to a table in Excel from Alteryx?

Thanks!

[atcodedog05]

Hi @asuamat 

Can you provide snapshot of your output tool config.

[Tyro_abc]

Hi @asuamat 

Yes, it is possible. Follow the steps

1. Create an excel file ( Ex. try.xlsx, with field name[ID, Name])

2. In your select tool create the table's field name as your excel file mentioned ( like ID, Name)

3. In the Output Data tool, choose the file and the sheet(where you want to save)   

It will say, the file already exists, do you want to replace it?  Press the YES button

4. Then it will ask for Sheet and range.

5. Change the field accordingly

I think it's work.

Regards

Arundhuti