Read html file from desktop

Hi,

I am creating app, which user is using to upload data. Client was using data in csv and excel format. Now he will also be loading html files. She will be loading data from her desktop, so I cannot use download html tool. The only solution for me was to change html to xml and load it. Unfortunately it doesn't load correctly, so I had to cleanse this data a bit (please find attached examples, I couldn't attach html or xml, but xml is embedded in workflow).

My question is whether I can upload html file to Alteryx without converting it to xml first (I don't want customer to do it). I am also concerned if my solution is robust. If not could you advice my something more robust?

example workflow.yxmd

Input

Parse

Accepted answers

seinchyiwoo

Hey,

You can read it directly without converting it.

Input Data > All Files > xxx.html > Read it as delimited text file > Other: \0:

Next you just have to go through the usual motion of data parsing in Designer.

Some examples of parsing HTML file here: https://community.alteryx.com/t5/Weekly-Challenge/Challenge-40-Parsing-a-HTML-File/td-p/36581

Cheers,

Seinchyi

All comments

seinchyiwoo

Hey,

You can read it directly without converting it.

Input Data > All Files > xxx.html > Read it as delimited text file > Other: \0:

Next you just have to go through the usual motion of data parsing in Designer.

Some examples of parsing HTML file here: https://community.alteryx.com/t5/Weekly-Challenge/Challenge-40-Parsing-a-HTML-File/td-p/36581

Cheers,

Seinchyi

Andrzej

Hi Seinchyi,

Thank you for this. I didn't know that input tool can actually read this file, because it didn't see it. I have to specify file name which I want to load by hand. I am still wondering if there is a way for input tool to see this file, because it is used by customer.

Greeting

Andrzej Gabryel

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703