Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

How do I pull a dynamic hyperlink from the source code?

Highlighted
8 - Asteroid

I'm trying to get Alteryx to pull a certain hyperlink from this source code view-source:https://www.fda.gov/drugs/drug-approvals-and-databases/approved-drug-products-therapeuti... (specifically line 484).

 

I think I could download the source code as text (although I'm not sure how) and change the text to columns and from there filter to the hyperlink I need. 

 

I'm wondering if it's possible to direct Alteryx to pull the data straight from that location so even if the hyperlink changes, the data will be updated. Or if not, if it's possible for Alteryx to automatically pull text data from the source code?

Highlighted
17 - Castor
17 - Castor

Hi @helenjin1 

 

Here's a WF that gets(eventually) your pdf.  It demonstrates the basics of web scraping

 

WF.png

 

It starts by building the absolute path from the site and relative path addresses.  The download tool gets the html from this path and the Text to Columns splits it to rows on the new line character.  After adding a Record ID, the filter pulls out line 484 and the Regex Parse tool gets the relative path.  

 

Since there's Patents page between the home page and the file you're looking for, the process repeats for this page.  

 

Finally in the PDF container, the pdf file is downloaded and saved to disk in the same directory as the workflow.

 

This isn't the best way to find this since the process uses line numbers to find the links.  You'll want to modify this to look for the HREF tags using some kind of search instead of using line numbers.  This will future-proof the workflow against any HTML changes that move the lines around

 

Dan

Highlighted
8 - Asteroid

Thank you! That was really helpful

Labels