Lookup from a blank dataset

[lynnliu]

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!

[Woth]

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

[lynnliu]

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!

[Woth]

Hello, Thanks for the clarifications.
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