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.

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels