Could you please tell me which PX stage I can use to filter out records based on a date that is > Date1 and <= Date2 where Date1 and Date2 are on a seperate file?
I have tried to use JOIN, MERGE and LOOKUP. They all seem to be looking at the keys being equal.
Thank you very much!
Fan
Filter Record with a Date
Moderators: chulett, rschirm, roy
Sinc your files not associated with any keys, you can add one. say an additional field called DUMMY in both the files . set the value of 1 for this field in both the files, so that all the records from file1 and file2 will be picked up. Then using the lookup bassed on this DUMMY key, you can select the records. By using the transformer, you can do the comparision.
-
- Participant
- Posts: 75
- Joined: Tue May 13, 2003 4:14 am
- Location: California
- Contact: