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
Comparison with Greater than
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
Re: Comparison with Greater than
Use join stage.
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am
Re: Comparison with Greater than
Depending upon your data volume use join stage or look up stage and then a filter stage
Soumya
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,
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: