title: Pentaho "Return value id can't be found in the input row"
body: <p>I have a pentaho transformation, which is used to read a text file, to check some conditions( from which you can have errors, such as the number should be a positive number). From this errors I'm creating an excel file and I need for my job the number of the lines in this error file plus to log which lines were with problem.</p>
  
  <p>The problem is that sometimes I have an error " the return values id can't be found in the input row".
  This error is not every time. The job is running every night and sometimes it can work without any problems like one month and in one sunny day I just have this error.
  I don't think that this is from the file, because if I execute the job again with the same file it is working. I can't understand what is the reason to fail, because it is saying the  value "id", but I don't have such a value/column. Why it is searching a value, which doesn't exists.
  Another strange thing is that normally the step, which fails should be executed at all( as far as I know), because no errors were found, so we don't have rows at all to this step.
  Maybe the problem is connected with the "Prioritize Stream" step? Here I'm getting all errors( which use exactly the same columns). I tried before the grouping steps to put a sorting, but it didn't help. Now I'm thinking to try with "Blocking step".
  The problem is that I don't know why this happen and how to fix it. Any suggestions?
  <a href="https://i.stack.imgur.com/6xrHD.png" rel="nofollow noreferrer">see here</a></p>