We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to split DownloadData (HTML meta data) into multiple columns based on tr> Tags

Mohd-Siddiqui1
8 - Asteroid

Hi there,

 

I have download data from a website in the form of HTML. I want to split the data contained in single column (DownloadData)

into multiple columns.

Condition for splitting is: Data contained in tags tr> to /tr> should be in one column, and the data in next tr> to /tr> should be in another column and so on.

 

Input Data:  

 

DownloadData
tr>
td>
p>
strong>Hello. This is test string.
/strong>
/p>
/td>
/tr>
tr>
td>

p>

a href="testLink"> XYZ Country
/a>
/p>
/td>
/tr>

 

Output Data:

 

DownloadData1DownloadData2
tr>tr>
td>td>
p>

p>

strong>Hello. This is test string.a href="testLink"> XYZ Country
/strong>/a>
/p>/p>
/td>/td>
/tr>/tr>

 

 

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @Mohd-Siddiqui1 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1641293576216.png

 

Hope this helps : )

 

Mohd-Siddiqui1
8 - Asteroid

Hi atcodedog05,

 

Thank you so much for the quick help. Really appreciated!

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Mohd-Siddiqui1 

Cheers and have a nice day!

Labels
Top Solution Authors