Insert/Update step: list of updated and inserted rows
I am using the Insert/Update step and I was wondering if there was any way to determine which of the lookup keys had been either inserted or updated in order to enable further processing based on this information.
I know I get the counts from the debug log but that isn't sufficient for my purpose.
I would like to have similar output from the Insert / Update step.
I am trying to further process the rows whose look up values matched AND update fields updated.
For example: If JobId = JobIdRisingTide AND JobStatusId <> JobStatus, then the Table field: JobStatusId will be updated with the Stream field. I would like to capture either of the two look up values from the output of the step. Not sure if this is possible though.
Any advice would be greatly appreciated.