Help required with download through a URL

[Anthony02]

Hi, I am trying to download the .xls file  available on the following  website by proving the download link available

https://data.gov.au/dataset/ds-dga-cfc1a18e-f4e0-4ed8-9a19-36b59b7a3d5b/distribution/dist-dga-931245...

But the data is not getting downloaded. Pls help

[OllieClarke]

Hi @Anthony02 

If you give the download tool https://data.gov.au/data/dataset/cfc1a18e-f4e0-4ed8-9a19-36b59b7a3d5b/resource/9312452f-fced-476e-a6... as its url, and then also create a filename in a formula tool. Then you can download this file to the location of your choosing

Hope that helps

[pedrodrfaria]

Hi @Anthony02 

Use the download tool to download the file to the desired location.

When clicking with the right and copying the address you get the following URL, which is a xlsx file.

https://data.gov.au/data/dataset/cfc1a18e-f4e0-4ed8-9a19-36b59b7a3d5b/resource/9312452f-fced-476e-a6...

I pasted this URL as a text input.

In Alteryx, set up to either save in a temp location for a desired definitive location

Then you either load it back into alteryx or you are done with it.

[Anthony02]

Thanks @OllieClarke

I want to create a Tableau data extract with this. Can you please help

Thanks,

[pedrodrfaria · Accepted solution]

@Anthony02 

Load that file into Alteryx afterwards, you can use the path it gives you to load it into alteryx. Then, if needed, manipulate it and then output it using the Output Data tool. 

Output data will allow you to output to a Tableau Data Extract file.