AnsweredAssumed Answered

Copy rows to result behavior

Question asked by Daniel Clark on Feb 19, 2019
Latest reply on Feb 20, 2019 by Sparkles Sparkles

I'm following this guide located at https://www.clearpeaks.com/copy-rows-to-result-in-kettle/. I'm using the REST client in one transformation to retrieve a resultset and then using the copy rows to result to pass the resultset to another transformation, where I access the individual fields as parameters. This is mostly working, however I'm finding that certain parameters that should contain a null value instead contain a value for previous field in the resultset. Is this expected behavior? Any ideas on how to overcome this? I'm using pdi 8.2.0.0-342. I have 'Execute every input row' checked.

masterjob_completed_courses_rept.pnghave a null value, get_limos_users_parameters.pngget_limos_users_exec.pngget_limos_users_transformation_get_variables.png

Outcomes