Alteryx Designer Desktop Discussions

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

Data Parsing to Rows

AshrafHaris
6 - Meteoroid

Hi All,

 

Can anyone help me to parse this 1 row data to multiple rows according to the number given

 

Thank You!

 

 
7 REPLIES 7
caltang
17 - Castor
17 - Castor

That looks like XML. Please provide relevant data to this use case, and kindly provide your criteria in as much detail as possible. If you have a workflow built halfway, kindly export that over as well.

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
AshrafHaris
6 - Meteoroid

Hi Caltang, the data was downloaded originally in an excel format. Which turns out in XML. There were no workflows involve, so here I attach along with the dataset only.

 

 

caltang
17 - Castor
17 - Castor

Your image is that of a Results pane... from a workflow... 

 

The data you provided doesn't have the columns you have - but I'll assume you only need rows from one example? You can pretty much duplicate the rest on your own thereafter.

 

Is that all you require?

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
caltang
17 - Castor
17 - Castor

Here's a sample. PFA.

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
flying008
15 - Aurora

Hi, @AshrafHaris 

 

FYI. Tokenize by :

<p>(.+?)<\/p>

 

录制_2023_10_23_13_13_04_471.gif

AshrafHaris
6 - Meteoroid

Yes Caltang this is what I wanted. I will replicate this and apply to all rows that have the XML format ! Thank You so much for the help 😊

AshrafHaris
6 - Meteoroid

This is cool, I have not thought of using Regex as a way to parse the rows. Thank you so much ! 😍

Labels
Top Solution Authors