Code: Select all
ID Name zip Date
1 RR 1121 12/20/2001
2 CC 1122 05/04/2002
3 QQ 2233 06/04/2002|11/20/2002
these dates into the column FDate.The derivation on the column should be
Code: Select all
IF RR=0
THEN SDate
ELSE
If RR<>0 and
Input.ID=Hash.ID and Input.Name=Hash.Name and Input.zip=Hash.zip and SDate>=FDate
then Hash.FDate
( It should take either of the date for ID 3 based on the condition)
Code: Select all
For Example:
ID Name zip FDate SDate RR
1 RR 1121 12/20/2001 12/20/2001 0
1 RR 1121 12/20/2001 12/20/2001 0
1 RR 1121 12/20/2001 12/20/2001 1
3 QQ 2233 06/04/2002 06/04/2002 0
4 QQ 2233 06/04/2002 07/06/2002 1
4 QQ 2233 06/04/2002 09/04/2002 1
4 QQ 2233 11/20/2002 11/20/2002 0
4 QQ 2233 11/20/2002 12/04/2002 1
4 QQ 2233 11/20/2002 01/04/2003 1
Hope I will be helped with some ideas on the derivation using field function or by some routines.
thanks