Talend community forum / [resolved] how to create TOS job for the following process

buzzy · 2010-07-01 08:33:44

hi gurus,
table1 table2
------ -------
currdate(field) nextreviewdate
| |
2009-12-01 2010-06-12
2009-05-25
2008-03-25
2009-09-25 ......

*note1: table1 field always having only one record.
*note2:table2 field having multifull records..

Question:-

need to compare table1 currdate field with table2 nextreviewdate field.

if (currdate(field) > nextreviewdate)
{
no need to consider to count record
}
else
count record.

output need: if (currdate(field) < nextreviewdate)/( (if (currdate(field) > nextreviewdate)) + (if (currdate(field) < nextreviewdate) ))

can possible to create TOS job for the above things?

pls let me know any one....

Rgds

remi · 2010-07-01 19:36:21

Hello Buzzy,

can't you use a tmap with table1 as the input and set table2 as a (Lookup) inpur.
Than for the ouput, you set your condition such as date1 > date2 (in the tmap) then go to a tjavarow and add count... something around those lines.
If this is not helpful enough tell me and I'll send you some screenshots.

Remi

lraulier · 2010-07-03 13:10:14

hi all,

do you have a lot of 'date' in your second table ?
it will be perhaps a good solution to sort your second table in a first time and count until (while) lower or greater depending on sort is desc or asc

regards
laurent

buzzy · 2010-07-06 11:55:33

hi guys,

the best solution is jst find out the months difference between two table fields,if it is -ve jst add to count,if is +ve no need......

Thanking u for ur co-operation.......

janhess · 2010-07-06 15:27:44

Can't you do it in SQL?

buzzy · 2010-07-07 11:55:22

by using ETL job,jst created one temp table,that table field showing the months difference field weather it is +ve or -ve.

i used talend date function in tmap.

Announcement

Unanswered posts

#1 2010-07-01 08:33:44

[resolved] how to create TOS job for the following process

#2 2010-07-01 19:36:21

Re: [resolved] how to create TOS job for the following process

#3 2010-07-03 13:10:14

Re: [resolved] how to create TOS job for the following process

#4 2010-07-06 11:55:33

Re: [resolved] how to create TOS job for the following process

#5 2010-07-06 15:27:44

Re: [resolved] how to create TOS job for the following process

#6 2010-07-07 11:55:22

Re: [resolved] how to create TOS job for the following process

Board footer