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

Alteryx Designer Desktop Discussions

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

How to extract table information from 15MB html file

JayTray
5 - Atom

I'm trying to query a table in a html file that is 15MB in size, the file is saved locally.

The HTML to text tool only allows just over 5MB.

Have any of you come across this before?

 

Thanks,

J

6 REPLIES 6
Raj
16 - Nebula

@JayTray 
this can be done using python or read as CSV and then transform it
find the reference
HTML format as Alteryx input - Alteryx Community
Convert HTML to text - Alteryx Community

Hope this helps.

apathetichell
19 - Altair

Ask the InformationLab.... @OllieClarke ?

OllieClarke
15 - Aurora
15 - Aurora

@apathetichell this is one of our French team’s tools. 

@Jean-Balteryx?

apathetichell
19 - Altair

The Wu-Tang Clan of Alteryx community. 

Jean-Balteryx
16 - Nebula
16 - Nebula

I'll check this internally with my colleague who created the macro !

william-lim
7 - Meteor

@JayTray Are you getting an error message ? If so, would you be able to share a screenshot of the error message you are getting ? Any information about the structure of the HTML file you are trying to parse or how you know that the macro is only handling up to 5MB of data would also be great, and if you could share a sample workflow that would be ideal!

Labels