Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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