Troubleshooting reading files

Despite the simplicity of reading files with PDI, errors appear. Many times the solution is simple but difficult to find if you are new to PDI. The following table gives you a list of common problems and possible solutions to take into account while reading and previewing a file:

Problem

Diagnostic

Possible solutions

You get the message: Sorry, no rows found to be previewed.

This happens when the input file does not exist or is empty.

Check the name of the input file. Verify the syntax used and check that you didn't put spaces or any strange character as part of the name.

Also, verify that you put the filename in the grid. If you just put it in the File or directory textbox, PDI will not read ...

Get Learning Pentaho Data Integration 8 CE - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.