topic Re: Conditional component, simple if true commit else die ... in Talend Studio

Conditional component, simple if true commit else die ...

Anonymous — Tue, 06 Nov 2018 14:33:27 GMT

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.

Re: Conditional component, simple if true commit else die ...

Aukema — Tue, 06 Nov 2018 15:05:00 GMT

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

Re: Conditional component, simple if true commit else die ...

Anonymous — Tue, 06 Nov 2018 16:04:25 GMT

Hi, unfortunately that doesn't seem to work...

First of all, my component called "Verification" is an input and not an output and then I don't understand how that could work because it doesn't seem that we are testing the equality between the two integer values.

Re: Conditional component, simple if true commit else die ...

Anonymous — Thu, 08 Nov 2018 07:35:23 GMT

That seems to be a quite basic thing, noone knows how i could do that ?

Thanks a lot.

Re: Conditional component, simple if true commit else die ...

Anonymous — Thu, 08 Nov 2018 10:50:05 GMT

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

Re: Conditional component, simple if true commit else die ...

Anonymous — Thu, 08 Nov 2018 11:12:26 GMT

How can i compare the two values in the Run If link ? I mean how do i get the value from the "tFixedFlowInput" component ?

Re: Conditional component, simple if true commit else die ...

Anonymous — Thu, 08 Nov 2018 11:31:03 GMT

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 !

Re: Conditional component, simple if true commit else die ...

Anonymous — Thu, 08 Nov 2018 13:28:54 GMT

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

Re: Conditional component, simple if true commit else die ...

Anonymous — Thu, 08 Nov 2018 13:44:56 GMT

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...

Re: Conditional component, simple if true commit else die ...

Anonymous — Thu, 08 Nov 2018 14:00:15 GMT

Hi,

Your first if condition check is giving the output as false (as shown in your screenshot) and second if condition is giving as true (which is going to tDie). So it seems the your if condition has some problem. Why don't you print the values using Java String.out function and see whether the values are matching or not?

You are just around the corner for the final solution. I would suggest you to do some debugging around that variables and you will be able to resolve the solution. In this way, you will never forget the concepts also.

If the answer has helped to answer your query, could you lease mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

Re: Conditional component, simple if true commit else die ...

Anonymous — Thu, 08 Nov 2018 14:07:21 GMT

My tJavaRow component already containt java system.out.println, that's why you can see some text printed "Before tDie 5414 5414". I display here my two variables and as you can see they are totally equals.

I guess this is and execution order issue because this text, as i writed, should be executed "before tDie" and that's apparently not happening this way. The content of my variables appears after the error message of my tDie component...

I also tried to move the code with my system.out.println inside the tJava component that is just before the tDie one, but after that onSubjobOk link. The result is strictly the same !

Re: Conditional component, simple if true commit else die ...

Anonymous — Thu, 08 Nov 2018 14:16:40 GMT

Hi,

Could you please share below details?

a) Screen shot of full job flow

b) Screen shot of the if condition you are using for comparison

c) Screen shots of current System Print commands you have given

Warm Regards,

Nikhil Thampi

Re: Conditional component, simple if true commit else die ...

Anonymous — Thu, 08 Nov 2018 14:41:07 GMT

Here all the screenshots you asked me

Result after running below. As you can see, the execution order seems correct after replacing tDie by tJava. I think the execution order was correct though but the tDie component might disturb the display...

Re: Conditional component, simple if true commit else die ...

Anonymous — Fri, 09 Nov 2018 10:47:53 GMT

Hi,

I'm back with a "solution" or rather a bypass...

After querying my first database with a select count(*) in order to get the number of rows expected in my second db (after insertions). I use a tMap to store the result of the comparison between my two values (see below).

Then I store this result in a global var (that could have been a context var) and I use it inside my RunIf links to test wether the comparison returned true or false.

This is working well but that's just a bypass. I really think there is a talend issue if I try to do this comparison right inside the RunIf links without doing it before in a tMap as I am doing now.