topic Re: Right components to store hours into shift time in Talend Studio

Right components to store hours into shift time

sebra123501 — Fri, 02 Jan 2026 14:45:42 GMT

Hi everybody,

Since my current customer doesn't want me to do a complex SQL script, he asks me to do things as much as possible with Talend components.

The problem is that I'm not at all familiar with LOOP and ITERATE.

So I submit here my problem to achieve the expected result with only Talend components (i

f it's really possible) :

I have to store hours from a table A linked to a table B which contains presence shift times.

It's not important in my exercise to store hours into morning or afternoon shift. I can stack mechanically into shift time, sorted by project num for example.

I know that I have to use many Tloop or/and Titerate to succeed but it's less obvious in Talend than in SQL for me.

Thanks you very much for your help.

Re: Right components to store hours into shift time

DKallmann — Sat, 18 Mar 2023 18:18:00 GMT

Hi,

Sorry, I don't understand why you don't use tJava to solve this. tLoop is usually choosen for files collection and tFlowToIterate (I guess you were fererring to this one) cannot include every conditions you need.

A part of Java Code seems necessary to achieve your job.

Re: Right components to store hours into shift time

sebra123501 — Sun, 19 Mar 2023 18:58:55 GMT

Thank you for your answer, the problem is that i am not an expert in Java at all 😕

Re: Right components to store hours into shift time

DKallmann — Sun, 19 Mar 2023 21:16:31 GMT

In this case, unless you integrate the right sql code into your source component, I don't see. Whatever your DBMS, I'm sure it would fit.