Filter Record with a Date

FanWeik · Post by **FanWeik** » Thu Jul 01, 2004 8:43 pm

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

mouthou · Post by **mouthou** » Mon Jul 05, 2004 12:30 am

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.

gh_amitava · Post by **gh_amitava** » Tue Jul 13, 2004 4:26 pm

Hi,

Use Filter Stage.. See the orchestrate manual for proper syntax..

Regards

Amitava