Parse CSV From Download Tool

Hi,

I am trying to connect to the New York Times' COVID data set, as maintained on their GitHub repository (https://raw.githubusercontent.com/nytimes/covid-19-data/master/live/us-counties.csv). I can point the download tool to this URL and successfully download the data, but how do I parse the multi line csv data from a single row into a full data set? I have used the parse tool successsfully in the past with json data, is there an equivalent for CSV data that is \n delimited between rows?

If the answer is no, one alternative is to use the download tool to save the data to a file and then import the file, which will come in as multiple rows. Is it possible to import the data within the same workflow? How can I force it to execute the download prior to importing?

Download

Accepted answers

fmvizcaino

Hi @Nsupple ,

You can use the text to columns with the \n delimiter to split your data into different rows.

Here is an example of the full parsing.

Best,

Fernando Vizcaino

2020-06-24 Parse CSV From Download Tool.yxmd

All comments

fmvizcaino

Hi @Nsupple ,

You can use the text to columns with the \n delimiter to split your data into different rows.

Here is an example of the full parsing.

Best,

Fernando Vizcaino

2020-06-24 Parse CSV From Download Tool.yxmd

Nsupple

Thank You. I tried this, but it turns out the machine I'm using at the moment has an older version of deigner when that tool required the user to specify the row count.

Works Great!

LEXQ2005

@fmvizcaino

fmvizcaino, I downloaded your workflow and ran it. The data process failed in the Download tool. Error message "Error transferring data: Failure when receiving data from the peer."

I'm searching in this community, trying to find an example solution of API Call CSV data.

bmangel

I've built a macro which does the job - you can find it here: https://community.alteryx.com/t5/Public-Community-Gallery/GitHub-csv-downloader/ta-p/1020479

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335