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

Alteryx Designer Desktop Discussions

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

Cell with multiple entries in a table from URL

BonusCup
11 - Bolide

UPDATE:  Workflow attached

 

 

I'm pulling in some data from the below link:
https://support.fubo.tv/hc/en-us/articles/115005151127

 

I'm familiar with using the Text Input > Download > Text to Columns and so on to scrape the URL for the data in a table but this is the first time I have run across a cell with multiple rows like the below:

BonusCup_1-1604420205330.png

 

The Albuquerque row comes across as:

DownloadData

 

 

<p><span style="font-weight: 400;">Albuquerque-Santa Fe, NM</span></p>
</td>
<td class="wysiwyg-text-align-center" style="width: 65px;">
<p><span style="font-weight: 400;">-</span></p>
</td>
<td class="wysiwyg-text-align-center" style="width: 50px;">
<p><span style="font-weight: 400;">-</span></p>
</td>
<td class="wysiwyg-text-align-center" style="width: 57px;">
<p><span style="font-weight: 400;">KRQE</span></p>
</td>
<td class="wysiwyg-text-align-center" style="width: 60px;">
<p><span style="font-weight: 400;">KOB</span></p>
</td>
<td class="wysiwyg-text-align-center" style="width: 50px;">
<p><span style="font-weight: 400;">-</span></p>
</td>
<td class="wysiwyg-text-align-center" style="width: 88px;">
<p><span style="font-weight: 400;">KASA</span></p>
<p><span style="font-weight: 400;">KRTN</span></p>
<p><span style="font-weight: 400;">KTEL</span></p>
</td>
<td class="wysiwyg-text-align-center" style="width: 73px;">
<p><span style="font-weight: 400;">KLUZ</span></p>
</td>
<td class="wysiwyg-text-align-center" style="width: 58px;">
<p><span style="font-weight: 400;">KTFQ</span></p>
</td>
</tr>
<tr>
<td class="wysiwyg-text-align-left" style="width: 113px;">

 

 

 

DESIRED RESULT:

DMA NameABCCBSFOXNBCThe CWTelemundoUnivisionUniMas
Albuquerque-Santa Fe, NM--KRQEKOB-KASA,KRTN,KTELKLUZKTFQ

 

My current workflow results split them out into their own cells which then throws the rest of the data off of their corresponding headers.

Capture.JPG

 
 

TIA for any help 

3 REPLIES 3

Hi @BonusCup 

 

Is the below what you are looking for? I believe the key here is to Transpose your data points then use the Summarize tool to concatenate the Albuquerque Telemundo values.

christine_assaad_0-1604447054139.png

 

BonusCup
11 - Bolide

@christine_assaad 

 

Thank you for your response. I understand how you got to the final results but I'm having an issue getting the 3 stations in the one cell under Telemundo to come out as 3 separate cells under Telemundo.

 

I've edited my first post to add my workflow.

 

BonusCup
11 - Bolide

These types of cells also appear in Palm Springs, CA and Waco-Temple-Bryan, TX

 

BonusCup_0-1604499536077.png

 

Labels
Top Solution Authors