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.