Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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