DSXchange

Hi, I have a problem in Lookup Stage parallel V 9.1

I do have a table with amount, the second table has ranges, in stream link I have defined the range for the amount

Example:
STREAM LINK
Key Field: BCOME
Amount: 2555,10

REFERENCE LINK
Key Field: BCOME
DSLink25.LWR_VAL: 0,00
DSLink25.UPR_VAL:3000,00

Stream link defined range
Range(DSLink25.LWR_VAL, ">=", DSLink25.UPR_VAL, "<=",0)) -> This line in red

When I compile the job, it shows me:

Column Amount: Range(DSLink25.LWR_VAL, ">=", DSLink25.UPR_VAL, "<=",0)
Variable 'Range' not defined

I appreciate your help

Hi,
Try reediting this range lookup; perhaps the entire build the entire stage a new.

The fact that it is red suggest that something is wrong!

also are you 100% sure that both links are sorted via the same key criteria?