I have a lookup stage which has input records with null values. Basically I want the lookup stage to Reject records when there are unmatched records but continue when there are null values on the key.
My input columns and receiving columns are nullable and Lookup Failure is set to 'Reject'
Not sure where i am going wrong.
Thanks in advance.
Regards,
Nikita
Do not want null value records to be rejected by Lookup Stg
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 6
- Joined: Mon May 06, 2019 6:42 am
Do not want null value records to be rejected by Lookup Stg
nikita bandekar
Take this with a grain of salt as it's been a long time but I think you'll need to stop rejecting any records by the Lookup stage. After the lookup, query the results and "reject" them yourself by looking for NULL values in the returned keys and compare that to the submitted keys. Decide based on the source values.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
A "conditional lookup"? All that comes to mind is something from years ago, a specific stage which was only available in the mainframe version of the product. Has that been merged into the core product?
Okay, a quick search seems to confirm my memory. It is only listed under the Mainframe Job Stages topic online and for some reason only up through the 9.x version of the product. Odd that trying to switch the version to 11.x give me an error about no matching topic.
Still seems to me that you will need to provide the conditional logic...
Okay, a quick search seems to confirm my memory. It is only listed under the Mainframe Job Stages topic online and for some reason only up through the 9.x version of the product. Odd that trying to switch the version to 11.x give me an error about no matching topic.
Still seems to me that you will need to provide the conditional logic...
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 6
- Joined: Mon May 06, 2019 6:42 am