DSXchange

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

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.

Hi,

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

Regards

Amitava