Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Downloading .csv File

insomned
8 - Asteroid

Hi everyone, 

 

I want the .csv from this link https://falextracts.s3.amazonaws.com/Contract%20Opportunities/datagov/ContractOpportunitiesFullCSV.c... to be downloaded by Alteryx with all the data read in (ie the same as I would input this file in Excel format). 

 

How can I achieve this?

 

Thanks! 

7 REPLIES 7
Felipe_Ribeir0
16 - Nebula

Ignore, didnt work

 

insomned
8 - Asteroid

Hi, 

 

Thanks but that I achieved myself. :D 

 

I need the actual .csv data (which is in the file) to be present.

 

Thanks!

Felipe_Ribeir0
16 - Nebula

Hi @insomned 

 

Now it is working. Take a look.

 

download.png

 

insomned
8 - Asteroid

But I still cannot see the data itself in Alteryx..

Felipe_Ribeir0
16 - Nebula

@insomned 

 

The previous version was just downloading, this new one will be able to download + import it to alteryx:

 

Screenshot 2023-08-23 132319.png

 

But i saw now that the link that you provided expired, it had some embedded authentication:

 

link.png

BecclesBen
7 - Meteor

This is great, thank you for sharing.

 

I hit a problem when trying to use it as the csv download file's data starts on line 6 - how would I insert that into the workflow to ensure I get the csv?

 

Thanks

 

[modified workflow attached]

BecclesBen
7 - Meteor

Found it - by editing the dynamic input

Labels