Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Neatly Display Download data that is returned in CSV format

asek
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

 

 

1 REPLY 1
DavidP
17 - Castor
17 - Castor

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