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

[Paritosh1]

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.

-

[Anonymous]

Hello,

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

tJDBCInput -> tFlowToIterate -> tJDBCInput-->tJava

|

onsubjobok

|

tsendmail

Best regards

Sabrina

[Paritosh1]

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.

[Anonymous]

Hello,

Would you mind posting your job setting screenshots on community?

Please mask your sensitive data.

Best regards

Sabrina

[Paritosh1]

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.