Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I just want to do a simple if statement between 2 integers in order to determine the next action : commit or die. But i don't find out how to manage that simple thing...
I use a tDBInput with a select count(*) in order to get my first integer. Then i use a tFixedFlowInput to get the second integer value with this expression ((Integer)globalMap.get("user_customer_NB_LINE_INSERTED")). Now i just need to compare these 2 values, commit if they are equals, die if they are different.
Can someone help me achieve this please ?
I tried using tMap, tFilterRow, RunIf but didn't find the right way...
Thanks,
Guillaume.
Hi,
From your DBoutput component you could do an "OnComponentOk" to the FixedFlowInput component. Then use the runIf trigger from the FixedFlowInput component. Use true to for you commit and false for the tDie.
See attached screenshot
Hi,
Could you please try below approach for your use case where you can load the count data from DB to a context variable using a tjavarow?
The second subjob will provide the NB_LINE count and in the Run if link, you can join between these two values to do the data comparison operation.
If the answer has helped to resolve your query, could you please mark the topic as closed? Kudos are also welcome 🙂
Warm Regards,
Nikhil Thampi
How can i compare the two values in the Run If link ? I mean how do i get the value from the "tFixedFlowInput" component ?
I did a little bit different and it seems to work ... upside down ...
My values are equals but the test returns me false ... See screenshots below :
First of all, my tjavarow component where I define my context variable and display both integer values
Then my first RunIf link running tDie if my values are different
Now my second RunIf link running a commit job if my values are equals
And finally the result i get after the execution of my job ...
As you can see my values are equals but i get the error !
Hi,
Unfortunately, you are trying to create the if condition at wrong area and you are not allowing the entire subjob to be completed. I would suggest you to always use On SubJob Ok trigger at the starting component of each subjob till you get more hands on with Talend. f you notice my job, its always staring from left to write and control goes to next area through On Subjob OK clause (which means the job will wait till the execution is complete of that full subjob before going to next Sub job).
For better readability, I have added a dummy tjava component which will control the flow.
Now, another thing if younotice, you are takig NB_LINE from wrong component inyour flow. You ha earlier specified that you want to compare the count between DB and file. So you need to take the first count from DB (may be by using a select count(*) ) and store it in context variable. Next, you will have to read the NB_LINE after reading the file.
Warm Regards,
Nikhil Thampi
Na i need to compare values from two DB's, the difference is that I am inserting rows in one of these DB juste before my select count(*).
That's why i use this formula : ((Integer)globalMap.get("tDBOutput_3_NB_LINE_INSERTED")). It returns me the number of rows inserted in my DB output. This number (of inserted rows) must be equal to the number of datas that I can find in an other DB (the one i query with my select count(*)).
Also, I have added an empty tjava component like you suggested in order to control the flow but that's not working. The flow is still running upside down...
There is a real issue with this flow ... my println are done after the execution of the tDie component (and that's why the test returns me an inequality) ... I don't understand how this could happen because I am using that "OnSubjobOk" link before the tDie component...