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