Range Lookup in Main Stream Flow

dsdoubt · Post by **dsdoubt** » Thu Jul 23, 2015 1:01 am

I have Main date field in Main stream of the lookup and I have Begin_DT and END_DT field in reference table.
How do I do range lookup based on the these date field (Begin_DT < Main_Dt < END_DT)?
Range lookup options in the stage gives me only Main stream fields for the Begin and End value.

Let me know, if there is a option?

Let me know, if I did not make the questions clear.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 23, 2015 1:31 am

You can do a range lookup on either the reference input or on the stream input. Examine the examples in the Knowledge Center or in the Parallel Job Developer's Guide.