Compare the two dates which is Greater

boppanakrishna · Post by **boppanakrishna** » Thu Oct 12, 2006 3:56 am

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

ray.wurlod · Post by **ray.wurlod** » Thu Oct 12, 2006 4:01 am

There are several ways to solve this. Do you have any ideas about how you wish to proceed? For example, is the comparison to be performed row by row?

boppanakrishna · Post by **boppanakrishna** » Thu Oct 12, 2006 5:44 am

hi Ray,
My second Dataset contains only one Date and based upon that date only i should pass the values to the target ,could you please tell me the stages to use also

Thanks,
Boppana

Kirtikumar · Post by **Kirtikumar** » Thu Oct 12, 2006 5:54 am

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

boppanakrishna · Post by **boppanakrishna** » Thu Oct 12, 2006 7:32 am

hi keerthi,
i will pass only the dates which are greater of the two dates to the target

Thanks
Boppana Ramakrishna

dsdev750 · Post by **dsdev750** » Thu Oct 12, 2006 7:43 am

In the first job, you could read the dataset first and pass the date to a second job as a job parameter(vDateParam). In the second job, use a transformer and a constraint to only let those records through where incoming date is > vDateParam.

chulett · Post by **chulett** » Thu Oct 12, 2006 7:49 am

Make sure your dates are in an ISO format, then a simple compare will work: YYYY-MM-DD or YYYYMMDD, for example.

ray.wurlod · Post by **ray.wurlod** » Thu Oct 12, 2006 2:20 pm

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.

ambasta · Post by **ambasta** » Thu Oct 12, 2006 2:26 pm

I think you can do this by converting your fields as datetosting or timestamptoString and then compare themn.I think this will work