Forum Discussion

BenFransen's avatar
BenFransen
Advocate II
9 years ago

External table is not in the expected format.

I have a data mutation process which is handled by Pentaho Kettle. Basically it reads several Excel-sheets, tidys up, rearranges, does some formatting, casting and sorting and writes it to an Excel-f...
Need Help
TheoC's avatar
TheoC
Community Champion
6 years ago

I found the error is likely linked to the source data file(s) being in ".XLS" format.  By saving these down as ".XLSX" format, you should find the error is corrected.

pmay's avatar
pmay
Resolver I
2 years ago

This isn't possible when you're reading from external data sources, like a government site.