Alteryx Designer Desktop Discussions

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

HTM file input in alteryx

Casp9846
5 - Atom

Hey - and happy new year.

I've a lot of datafiles (HTM files) with postings see below in attachment. 
I've to extract account number (orange field), dato, tekst, traksaktion, bilag, debit, kredit and saldo.
But when i read it into alteryx as an an .htm file and choose CVS option, i'd only get bilagsnummer, debit and credit. 
Does any of you know
1. how to read everything in alteryx
2. read multiply htm files at once - i've tried with *.htm but it return with an error.

Sincerely

 

 

Casp9846_0-1672403976547.png

 

Casp9846_1-1672404094419.png

 

1 REPLY 1
MatthewO
Alteryx
Alteryx

@Casp9846 one approach is to read the files in as blobs, then convert them to text. The blob input tool supports reading multiple files as well. This will result in one row of data, containing all of the HTML content, for each file. You can continue to parse the desired values from there. The workflow and sample files are attached.

 

image.png

Labels