community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

XML dowload

Alteryx Certified Partner

Greetings,

 

I have a question to download and parse this information in XML.

 

http://qa.in-touch.cl/dercocenter/ws_ticket/Dercocenter_Tickets.asmx?op=Consulta_Tickets

 

I am using the download tool but it gives me error in the download.

 

Imagen1.pngError

Thanks for your help!!

Alteryx Certified Partner

if you look at the data in the DownloadData cell you will see that there was no error and data came through.  teh reason it is red, is that there are a large number of records which are considered "NOT OK" in terms of data quality.  it is because many records have leading or trailing spaces.

If you put a text to columns tool after this and parse to rows by using \n (new line) as the delimiter, you will see that all of your data is there.  I'm not an XML pro so I would have to work on this further to parse out the xml more expertly :-)

Maureen

screenshot.JPG

Alteryx Certified Partner

Imagen1.png

 

 

Dynamomo, 

I'm following the steps you told me but I don't have the same results. Can you help me please? (I'm new with alteryx)

Alteryx Certified Partner

You have selected split to columns (notice the additional 3 columns).  You need to select split to rows.

see attached workflow

Highlighted
Alteryx Certified Partner

Thanks for your help!!!! :D I'm going to try to parse this file. 

Labels