topic job depends from changeable values in Talend Studio

job depends from changeable values

MaryL — Wed, 29 Jul 2020 16:53:50 GMT

Hello!

There is table with changeable values: two dates. And I need to create job which would run only if today is between that two dates from table.

Is it possible to do? And how? Could you please help.

Re: job depends from changeable values

evansdar — Wed, 29 Jul 2020 18:22:10 GMT

You could use a 'Run If' connection based on comparing 2 dates (TalendDate)

Run Iff: Current Date < date1 and Current Date > date2

Re: job depends from changeable values

MaryL — Thu, 30 Jul 2020 05:41:15 GMT

yeah, but dates are often changed, so maybe Run If can check dates from table?

Re: job depends from changeable values

Anonymous — Thu, 30 Jul 2020 09:49:58 GMT

@Maryna Lykhoshva , You need to read dates from table, and then check if today is between the two dates on a tJavaRow, trigger the next processing using RunIf based on the checking result. The job looks like:

tMysqlInput--main--tJavaRow---runIf---next processing

on tJavaRow:

if(TalendDate.compareDate(TalendDate.getCurrentDate(), input_row.dateColumn1)==1&&TalendDate.compareDate(TalendDate.getCurrentDate(), input_row.dateColumn2)==-1){

context.condition=true;

}else{

context.condition=false;

}

//context.condition is context variable, boolean type, set its default value as false.

set the condition of runIf as: context.condition

Hope it helps you!

Regards

Shong

Re: job depends from changeable values

MaryL — Fri, 31 Jul 2020 06:17:24 GMT

Thank you!

I'll try.