Pentaho kettle transformation - Empty CSV file input step skip subsequent steps

0
votes

I have a kettle transformation which has a csv file input step. I would like the transformation to just skip all the subsequent steps in the transformation if the csv file has no data (empty). Is there a way to achieve this?

2
pentahokettle
You will probably want to define this logic in a Job file (sequential execution in Jobs vs concurrent execution in Transformations). – Noah

2 Answers

1
votes

Try the step "Detect Empty Stream" and check for NULL condition for any one of the columns from the CSV.

Appending a link from PDI Wiki: http://wiki.pentaho.com/display/EAI/Detect+empty+stream

1
votes

Otherwise, you could use the step "Get File Names". This returns many fields, one of which is the field "size". After this you can put a "Filter rows" step that sends the flow to a "Dummy" step if the size is equale to 0.