Dynamic Input issue (Download Excel from URL)

[Stanislaw]

Hello everybody,

I'm having a problem with downloading/processing Excel files from URL.

I managed to download the file itself, but I get an error message from the Dynamic Input Data tool: "No table chosen".

Even though I think I have chosen the sheet.

Could you please help me? (please see the attachment)

 Thank you!

[Luke_C]

Hi @Stanislaw 

When you use the 'change entire file path' option with excels, it also affects which table (tab) is chosen. Since the filename field doesn't have this, it fails. 

If you add a new field that is C:\[File path]\SourceFile.xls|||'Table 57$' and reference that in the dynamic input rather than the current filename, it seems to work. 

[Stanislaw]

Hello @Luke_C 

Thank you for your reply.

Where/how should I add this new field?

I've changed this field, but it doesn't work.

Thank you!

[Qiu]

@Stanislaw 

Were you able to open the output Excel file?

I can not even open the file and error messages say the file is corrupted.

I found this

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Download-Tool/td-p/501305

Are you running the Administrator version of Alteryx?

[Stanislaw]

@Qiu  - yes, it's the Administrator version.

The file itself seems to be all right.

I can download it and open it.

URL: https://www.ons.gov.uk/file?uri=/economy/inflationandpriceindices/datasets/consumerpriceinflation/cu...

[Qiu · Accepted solution]

@Stanislaw 
I was wrong about the xls and xlsx.

I think now its working by adding the Sheet Name to the full path.

[Stanislaw]

Thank you, it works! 🙂

[Qiu]

@Stanislaw 
Glad it helps and thanks for the accept mark. 😁