Alteryx Designer Desktop Discussions

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

Unstack Odd/Even from HTML Regex to Create Table

w_gore
8 - Asteroid

I am trying to unstack the results from parsing data from field in .kml using RegEx.  My regex is <[^>]+>([^<]+)</[^>]+> with tokenize output split to rows.  One record would be Name - Value Odd - Value Even, then repeat.  My current dataset consists of 66 records per name.  Recommendations on unstacking or working with HTML data to end up with a nice table?  May look at Python using beautifulsoup, which is a learning curve.  Thanks folks.

 

Unstack Odd and Even.jpg

4 REPLIES 4
CoG
13 - Pulsar

Can you use the Formula Tool on the Counter to half the increment? Floor(([Counter]+1)/2,1). Here is a sample:

Screenshot.png

Qiu
21 - Polaris
21 - Polaris

@w_gore 
Similar with the approach of @CoG but with my favorite Tile tool 😁

1202-w_gore.png

w_gore
8 - Asteroid

Thanks Andrew and Qiu.  Both solved my problem. I've not used the Tile tool before.

Qiu
21 - Polaris
21 - Polaris

@w_gore 
Glad to help.

Labels