Date difference then compare to a range

I am using Oracle DB.

I have successfully transformed DATE OF BIRTH to AGE by using REFORMAT DATE and CURRENT DATE connected to DATE DIFF. So I get 14 ---for the age.

I TARGET table has AGE range columns: 10-20 yrs, 21-30 yrs, etc.

How do I use IF NUMBER IS BETWEEN to route to the correct TARGET TABLE COLUMN?

I have used the IF NUMBER IS BETWEEN but the 14 disappears when connected.

Thanks

Please follow the forum rules and post the screenshots

Mike

Hope these screen shots help.

Srini

For if number between you have to link Success and Failure to something as well.

Mike

SCRENSHOTS = Attached 5 screen shots
VERSION NUMBER= Adv ETL Processor Version 3.7.0.6 AND Visual Importer Enterprise Version 8.3.4.3

OPERATION SYSTEM VERSION= Windows 7 Ultimate SP 1
DATABASE VERSION= Oracle 11g 32 Bit


DETAILED DESCRIPTION OF THE PROBLEM =

I attached the Input to the value, success & failure of the IF NUMBER BETWEEN, then attached the Output to one FIELD. Attached the output to the next IF NUMBER BETWEEN.

But both show 14 regardless of range restriction.

What am I doing wrong?

Thanks again, Mike.

I guess you are trying to set a flag

value =14
if value between 1 and 17 then success else failure

what you are doing instead

value=14
if value between 1 and 17 then value else value
so you get 14 all the time

Add two literals
set one to true
second to false
link them to success and failure

Mike