Forum Discussion

BenFransen's avatar
BenFransen
Icon for Advocate II rankAdvocate 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
Icon for Community Champion rankCommunity 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
Icon for Resolver I rankResolver I
2 years ago

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