Alteryx Designer Desktop Discussions

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

Read data from HTML script

NiranjanK1
8 - Asteroid

Hello All,

 

Below attached HTML format data will change on dynamically, i am trying to read the data from HTML script, my workflow is not filtering the data dynamically. Kindly help me

 

Regards,

Navin K

3 REPLIES 3
AbhilashR
15 - Aurora
15 - Aurora

Hi Navin, I used the approach of using a single Regex tool and identify text between the <p> tags. Does this work?

 

EDIT - looking at your other posts on this topic I realized there were multiple columns with HTML tag. I have updated my solution and reattached.

DavidP
17 - Castor
17 - Castor

This is the same as your other post right? I already replied there.

 

My suggestion is that you transpose the data to a name and value field, parse the value field with text to rows and \n delimiter and then use the regex I provided to extract the data from the html.

 

Example workflow attached

 

DavidP_0-1585751790318.png

 

NiranjanK1
8 - Asteroid

@DavidP  Thanks a lot David for your help.

Labels