I have created a transformation which reads the input from csv file and dump it into database table. In this transformation I have used csv file input -> sort step-> unique row step->table output. I have also used excel output in which I am putting the duplicate records which I am getting from unique row step.
Earlier I was using pdi-ce-4.2.0-stable in which this transformation was working fine. Now when I have switched to 4.3.0 it's not working correctly in that. Issue is that, the unique row step always redirecting first row to the error step even that is not duplicate.
1. 8 rows in input to Unique row (Nothing is duplicate in that)
2. Unique row is passing all 8 rows to the table output.
3. Unique row is always passing first row (out of 8) to the error step (excel output).
Please let me know how can I overcome to this problem?