Parse CSV From Download Tool

[Nsupple]

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?

[fmvizcaino · Accepted solution]

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

[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