In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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
14 - Magnetar

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
Top Solution Authors