Downloading data using API

[AryanMahak]

Hi Everyone,

I am very new to Alteryx and doing my first workflow using API. I need to download data from openflights.org.

Data is not coming in proper format and all records are not getting downloaded.

Here is the url used in Workflow.

https://raw.githubusercontent.com/jpatokal/openflights/master/data/airports.dat

Attached is my workflow.

Requesting the expert to help me to get the data.

Thanks!

Regards

Rajesh

[christine_assaad]

Hi @AryanMahak 

Could you please in Text to column change the delimiter to \n (lower case n)?

[echuong1]

Your approach was correct! Use a "\n" as the delimiter in the first text to columns to split to rows. This represents a new line. From there, you can use a text to columns to separate out the individual columns. I chose to ignore delimiters in quotation marks, since a comma is pretty common. I then used a multi-field formula to remove the " from all fields. You can rename the columns in the Select at the end.

Hope this helps!