Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Neatly Display Download data that is returned in CSV format

Highlighted
7 - Meteor

Hello, 

 

I am reaching out to an API that seems to be returning DownloadData in CSV format (I say think because the headers and data are separated by a semicolon which i read is UK format). I can't attach a sample but I will do my best to describe it.

 

I have a Text input with the URL as a field. The download tool grabs that data. DownloadData shows up as RED but the data inside the cell has the following format:

 

Domain;Organic Traffic

test.com;1

 

My goal is to use the browse tool and see the data in table format as so:

 

Domain               Organic Traffic

test.com              1

 

I am new to Alteryx and still learning the tools. 

 

Thanks

 

 

Highlighted
16 - Nebula

The red probably means there are leading or trailing white space, which you can remove with a data cleanse tool. You can use the Text to columns tool to split the data into 2 columns

 

DavidP_0-1582155253107.png

 

Labels