Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How can I give different response when rows found and when zero rows found. below is my job.
I am able to get a response, but how can we respond when there are no rows.
Thanks.
Hi,
Could you please check using the parameters shown in the screenshot?
Please note that this value will be available after the operation. So you will have to split your operation to two subjobs. The first subjob should end with DBOutput Insert.
In the second subjob, you can use a tJava or Runif or similar component to check the condition and send the necessary response.
Warm Regards,
Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved
Hi,
For query operation, why don't you replicate your output result set to two operations using tReplicate Command? The first flow can be used to do aggregation (using tAggregateRow) where you can count the number of records passed from DB. The second flow will have original records.
Warm Regards,
Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved