Comparison with Greater than

[Nagac]

Hi

I need all records from File1 which are satifies File1.Date>File2.Date(field is from File2).

Which stage can be used to achieve this?

Thanks in advace

[samyamkrishna]

Use join stage.

[soumya5891]

Depending upon your data volume use join stage or look up stage and then a filter stage

[Nagac]

How do we use Join or Lookup stage.

I tried but i could not find any option to compare with this logic. one more thing is that we dont have matched key fields. we get only one value from reference data(File2.date).

[jwiles]

Use Column Generator stages to add a match key with a single value to both inputs, then use a lookup to match them together and place File2.date on the output. Use a Filter or Transformer to compare the dates after the lookup.

Regards,

[soumya5891]

You can also use transformer stage in both the source to derive a user defined col and then do a look up on the basis of those columns

[ray.wurlod]

A range lookup would probably work, with the upper end of the range being some absurdly large value.