topic Re: How To Execute saved query from database table and then combine all result set in tJavaRow in Talend Studio

How To Execute saved query from database table and then combine all result set in tJavaRow

Paritosh1 — Sat, 16 Nov 2024 00:05:22 GMT

Hi All,

I am facing an issue while executing the query saved in the database and then consolidating it into the tJavaRow.

I need to fetch the saved query from database and then execute it on run time and then need to send consolidated report via email. For this, I am using the below flow.

tJBBCInput -> tFlowToIterate -> tjdbcinput (toexecute saved query in database table) and then need the consolidate records in tJavaRow In One flow. That I am not able to that.

Can you please help me to resolve this issue.

Thanks in advance.

Re: How To Execute saved query from database table and then combine all result set in tJavaRow

Anonymous — Fri, 04 Jun 2021 06:10:07 GMT

Hello,

If we understand your requirement very well, please try this work flow:

tJDBCInput -> tFlowToIterate -> tJDBCInput-->tJava

onsubjobok

tsendmail

Best regards

Sabrina

Re: How To Execute saved query from database table and then combine all result set in tJavaRow

Paritosh1 — Fri, 04 Jun 2021 07:09:51 GMT

Thanks for your reply.

The first tJDBCInput is having 4 records set means four query and I need to execute each query one by one and then need to consolidate.

Above flow will execute one by one. But we need all output in one go which is executed in second tJBDCinput.

Re: How To Execute saved query from database table and then combine all result set in tJavaRow

Anonymous — Fri, 04 Jun 2021 09:25:08 GMT

Hello,

Would you mind posting your job setting screenshots on community?

Please mask your sensitive data.

Best regards

Sabrina

Re: How To Execute saved query from database table and then combine all result set in tJavaRow

Paritosh1 — Mon, 07 Jun 2021 12:15:45 GMT

Sorry for the delay in response.

I have used the tUnite component to achieve the desired flow. Now My flow is:

tJDBCInput -> tFlowToIterate -> tJDBCInput-->tMap-->tUnite-->tMap-->tJavaRow

Let me know if there is any drawback of using the tUnite.