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 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.
