Hi all,
I am going to perform a lookup from a lookup dataset, the dataset may or may not be blank (without record). If the dataset is empty, when processing, error come out? Anyway I can merge / lookup / join a blank lookup file?
Thanks!
Lookup from a blank dataset
Moderators: chulett, rschirm, roy
Re: Lookup from a blank dataset
Hello,
It HAS (the dataset) to exist and I'm positive that you will get an error when the dataset that you are looking up is empty, you'll get a warning for sure. I need more information about what you are trying to do here, a lookup from a lookup?
[quote="lynnliu"]
I am going to perform a lookup from a lookup dataset, [/quote]
thanks
It HAS (the dataset) to exist and I'm positive that you will get an error when the dataset that you are looking up is empty, you'll get a warning for sure. I need more information about what you are trying to do here, a lookup from a lookup?
[quote="lynnliu"]
I am going to perform a lookup from a lookup dataset, [/quote]
thanks
The case as follows:
1. A master input file, based on the business rules, it may or may not generate a master reject file which failed on the business rules checking.
2. Then if master record rejected, all the related child records should reject.
3. Therefore, I need to perform a lookup for Child records to master reject file
Any suggestion?
Thanks!
1. A master input file, based on the business rules, it may or may not generate a master reject file which failed on the business rules checking.
2. Then if master record rejected, all the related child records should reject.
3. Therefore, I need to perform a lookup for Child records to master reject file
Any suggestion?
Thanks!
Hello, Thanks for the clarifications.
Let me draw this for ya:
Basically, the after the transformer takes the decision (according to the business rules), the lookup check in the reject files for the parent, if it matches, the record is rejected, if not, all is Ok.
If you need more explenations, dont hesitate...
Woth
Let me draw this for ya:
Code: Select all
InputFile-----Transform------Lookup-------OutputFile
| | |
| | |
Reject file | |
| | |
| | |
Funnel |
| |
RejectFile
Basically, the after the transformer takes the decision (according to the business rules), the lookup check in the reject files for the parent, if it matches, the record is rejected, if not, all is Ok.
If you need more explenations, dont hesitate...
Woth
Code: Select all