Compare the two dates which is Greater
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 106
- Joined: Thu Jul 27, 2006 10:05 pm
- Location: Mumbai
Compare the two dates which is Greater
hi all,
I have two source files , one is main source which contains columns like "sno","Date",and the other file contains only one column "ADate",
now i want to compare the "Date " column from first source with the "ADate" , and if the Date of " Date" column in first file is greater than the date of "Adate " then only i should pass it into the target ...
Thanks in Advance
Boppana Krishna
I have two source files , one is main source which contains columns like "sno","Date",and the other file contains only one column "ADate",
now i want to compare the "Date " column from first source with the "ADate" , and if the Date of " Date" column in first file is greater than the date of "Adate " then only i should pass it into the target ...
Thanks in Advance
Boppana Krishna
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 106
- Joined: Thu Jul 27, 2006 10:05 pm
- Location: Mumbai
-
- Participant
- Posts: 437
- Joined: Fri Oct 15, 2004 6:13 am
- Location: Pune, India
What do you mean by based upon that date?
Does this mean - if the Date coming from second dataset is null then pass it or if it is equal to current date then pass it?
It is diff to get anything from the what you are saying. Can you please mention what is your condition on which record should be passed to target
Does this mean - if the Date coming from second dataset is null then pass it or if it is equal to current date then pass it?
It is diff to get anything from the what you are saying. Can you please mention what is your condition on which record should be passed to target
Regards,
S. Kirtikumar.
S. Kirtikumar.
-
- Participant
- Posts: 106
- Joined: Thu Jul 27, 2006 10:05 pm
- Location: Mumbai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can do it in one job. Perform the full outer join, then use a downstream Filter stage to constrain the rows passed through. I needed to be certain of what you needed to do.
Last edited by ray.wurlod on Thu Oct 12, 2006 2:46 pm, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.