Read HTML data

[k10shirole]

Is there any way to read HTML data into Alteryx? The input data tool does not have any option to select HTML data.

Thanks!

[DylanB · Accepted solution]

You can either read it as an xml (which can fail due to whitespacing issues) or read it in as a .csv and use "\0" as your delimiter. Make sure your field length is adequately large so that no lines are truncated. If you need to get it into the same row from the csv read, you can then use the Summarize tool to concatenate the lines of html.

[k10shirole]

Thanks! It works perfectly. :)