Right components to store hours into shift time

[sebra123501]

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.

[DKallmann]

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.

[sebra123501]

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

[DKallmann]

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.