topic Tloop- compare hour with a value in Talend Studio

Tloop- compare hour with a value

borrisbeck — Tue, 06 Mar 2018 21:26:06 GMT

Hi
I need the twaitforfile activity component to run until 4.pm, so I’m using the below condition coded in tloop component ( which is, trying to compare the current hour with a value) but I’m getting into various issues, any help is appreciated.
Bigdecimal((TalendDate.getdate(“HH”)).compareTo(16) == -1

Thanks
Mj

Re: Tloop- compare hour with a value

Jesperrekuh — Tue, 06 Mar 2018 21:44:30 GMT

Bigdecimal((TalendDate.getdate(“HH”)).compareTo(  BigDecimal.valueOf(16)  )

Re: Tloop- compare hour with a value

TRF — Tue, 06 Mar 2018 21:56:34 GMT

Or this one without conversion:
(TalendDate.getdate(“HH”)).equals("16")
Should work.

Re: Tloop- compare hour with a value

borrisbeck — Wed, 07 Mar 2018 14:51:05 GMT

Thanks for responding, I tried that command, below is the exact command i used, actually my job may start around 8 and it has to run until 4.00 PM, with some sleep time in between. so i'm checking the current hour and minutes. for testing purpose i used a different time here,

(Bigdecimal((TalendDate.getdate("HH")).compareTo(Bigdecimal.valueof(10)) == -1 || Bigdecimal((TalendDate.getdate("HH")).compareTo(Bigdecimal.valueof(10)) == 0)))&&(Bigdecimal((TalendDate.getdate("mm")).compareTo(Bigdecimal.valueof(35)) == -1)  || (Bigdecimal((TalendDate.getdate("mm")).compareTo(Bigdecimal.valueof(35)) == 0)))

but the job is failing with error

	- The method getdate(String) is undefined for the type TalendDate
	- Bigdecimal cannot be resolved

Re: Tloop- compare hour with a value

Jesperrekuh — Wed, 07 Mar 2018 17:00:33 GMT

I put this in a tJava component and run this code.


Date x = routines.TalendDate.parseDate("HH:mm:ss", "12:00:00");
Date y = routines.TalendDate.parseDate("HH:mm:ss", "14:00:00");
System.out.println(y.after(x));

This is more elegant

Re: Tloop- compare hour with a value

borrisbeck — Wed, 07 Mar 2018 18:17:42 GMT

Sorry, not sure, how can i use this in the tloop?

Re: Tloop- compare hour with a value

borrisbeck — Wed, 07 Mar 2018 21:40:07 GMT

Hi
I have thought about the .equals solution, but it won’t work because, I want the job to run until the current time is less than or equal to 4 , that’s why I opted for the CompareTo operator.....

Any other ideas please

Thanks
MJ

Re: Tloop- compare hour with a value

Jesperrekuh — Wed, 07 Mar 2018 22:26:43 GMT

You want to run ... from startime : 05:00 until 16:30

in tLoop change loop type from FOR into a WHILE,

next copypaste this into condition:

routines.TalendDate.parseDate("HH:mm:ss",routines.TalendDate.getDate("HH:mm:ss") ).before(routines.TalendDate.parseDate("HH:mm:ss", "16:30:00"))

you can leave the int i=0 and int++ as is...

If you want to poll every second... connect via iterate a tSleep.

I've tested above solution and it works!

If not the case I really dont get what you trying to achieve...

tLoop.jpg