Pull in CSV data from websites through Alteryx

[Theodorelsmith30]

Hello All,

Apologies as I'm new to Alteryx and the community, but appreciate your time, patience and assistance. I was looking to pull in some data related to COVID-19 to further query, and wanted to circumvent having to download the files daily/weekly if possible. Is there a way to setup something in Alteryx that would pull the CSV information at runtime from the two URLS below into Alteryx such that I could run a join on the them and further query the specific information I need from these two sources?

https://raw.githubusercontent.com/nytimes/covid-19-data/master/us-states.csv

https://www2.census.gov/programs-surveys/popest/datasets/2010-2019/counties/totals/co-est2019-alldat...

I've tried looking at similar questions and solutions, but am still having trouble designing a simple workflow to do so. Thanks!

[AbhilashR]

Hi @Theodorelsmith30, some of the existing Alteryx community members have been working on similar projects. Take a look at some of the attachments in this community thread: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Time-Series-Data-COVID-19/td-p/543104/...

Might serve as a good starting point, reference, and challenges they faced in their journey.

Generally speaking, you could use the Download tool to fetch data into Alteryx from the URL's you mentioned. Using the examples mentioned in the thread, give it a try and let us know if you run into challenges.

[fmvizcaino · Accepted solution]

Hi @Theodorelsmith30 ,

For that, you can use the download tool to get all data from both URLs and to use a text to column tool to separate the data.

Best,

Fernando Vizcaino

[Theodorelsmith30]

Thanks so much for notifying me of this! It's really great to see! Unfortunately I keep running into an error at the second step (download) that reads "Error transferring data: Failure when receiving data from the peer". I'm guessing this is potentially related to my organization's firewall settings, which I've seen as a common issue for others with similar inquiries in these forms.

[Theodorelsmith30]

Thanks so much! This generally aligns with what I tried the first few attemps, but I'm hitting an "Error transferring data: Failure when receiving data from the peer". I'm guessing this is due to firewall settings with my company, but really appreciate your assistance and prompt response!

[fmvizcaino]

Hi @Theodorelsmith30 ,

It may be related to the firewall settings but also related to a non-admin version of Alteryx designer, do you know if that is the case?

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Installing-Admin-vs-Non-Admin/ta-p/...

In the post comments, you can see as well how to check if you are running a non admin version.

Best,

Fernando Vizcaino

[Theodorelsmith30]

Oh! Great call - I checked and am running the (USER) version and not the Admin version it appears...