topic Re: Filtering tDBInputs in Talend Studio

Filtering tDBInputs

Talindra — Fri, 15 Nov 2024 23:05:57 GMT

Hi everyone.

I have two INPUTS (INPUT 1 and 2).

This two INPUTS goes to a tUnite component.

This tUnite components goes to an OUTPUT to insert in a table.

I want a filter (maybe with a tFilter component?) that if this tUnite doesn't have any rows (the INPUTS not return nothing), another INPUT (INPUT 3) is who has to make a select and go to the OUTPUT to insert.

Simple conditions:

IF INPUT 1/2 rows > 1 THEN go to OUTPUT (of course if INPUT 1/2 doesn't have any rows, INPUT 3 go to OUTPUT)

How can be possible?

Re: Filtering tDBInputs

gjeremy1617088143 — Fri, 25 Mar 2022 08:16:13 GMT

Hi, it depend of the amount of data, you can try to rely your tUnite to a tHashOutput component and

after a on subjok ok between your first db input and an empty tJava your rely the tJava with an run if link to a tHashInput component with this condition :

tHashOutput_1_NB_LINE != null && tHashOutput_1_NB_LINE >0

so if the tUnite return some lines tHasInput will transfert the data store in the tHashOutput.

if you don't want to surcharge the memory you can rely the tUnite to an empty tJava with a main link

and chek tUnite_4_NB_LINE variable the same way as mentioned before.

then if it's not empty you request again with two new tDBinput.

Re: Filtering tDBInputs

Talindra — Tue, 29 Mar 2022 17:00:22 GMT

thanks for the response. what is a tHashOutput? I dont find that element

Re: Filtering tDBInputs

gjeremy1617088143 — Tue, 29 Mar 2022 18:02:41 GMT

Hi @Ivan R you have to go to project settings -> designer ->palette then you open the technical folder of the hide section and you drag and drop tHash input and output to the show section then you select apply and close.

tHash component will be available in the palette, they are similar to tBuffer component but with more options.

https://help.talend.com/r/en-US/7.3/technical/thashinput

Re: Filtering tDBInputs

Talindra — Wed, 30 Mar 2022 10:20:44 GMT

Thank you gjeremy. Im trying the second way you mentioned, without the tHash components.

But I don't understand exactly the flow. The tUnite must to be connected to the tJava as main with the condition? And then? I can't put a runif to the tAggregaterow...

And what's the thing with the input 3?

I have the flow as this right now

Re: Filtering tDBInputs

gjeremy1617088143 — Thu, 31 Mar 2022 07:16:52 GMT

hi , the purpose is to call the db two time , in the first one before tUnite you can try just a count on your value in the sql query ,

or sent like you do in the Input 1, send to an empty tjava, then you put an on subjob ok link between OFFERTAS_IBE_FUT_D+1 and a new tJava,

then you link the new tjava with the same job you do for input 1 with a run if link and in this link you put the condition .

Re: Filtering tDBInputs

Talindra — Thu, 31 Mar 2022 12:52:16 GMT

Hi!

I put a tJava from INPUT1 with a SubjobOk, but then I can't put a runif from this tJava to the INPUT1 again... it don't let me

Re: Filtering tDBInputs

gjeremy1617088143 — Thu, 31 Mar 2022 14:12:29 GMT

when i said the same job you you do for input1 --> you have to create new input 1 and input 2