Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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