topic Re: Tmap assigns the same value to different variables in Talend Studio

Tmap assigns the same value to different variables

AlSalvC — Fri, 15 Nov 2024 21:43:45 GMT

Hi everyone, I'm trying to assign different values to some variables but I get the same result in the 3 of them. The expression structure is the same but the input columns change. The expression is this one:

out2.Delta01 == null ?

null

String.valueOf(Float.parseFloat(out2.Delta01)/Float.parseFloat(out2.DestinationSum01))

All the 3 variables get the same result which isnt even correct for any of them. It is a simple division, so I dont know where is the problem. The input rows are strings, thats why the conversion.

Yes, I have verified that the expression variables are set on the correct output columns.

The results I get are in the attached photo.

Thank you for your help.

Re: Tmap assigns the same value to different variables

Anonymous — Wed, 07 Jun 2023 03:35:11 GMT

Hello,

Elaborating your case with an example with input and expected output values will be helpful for us to understand your requirement and situation.

And please post your tMap Map Editor screenshot with If/else statement here.

Best regards

Sabrina

Re: Tmap assigns the same value to different variables

pablo125 — Wed, 07 Jun 2023 06:00:33 GMT

I read your Question so I think that is like Verify the input data: Double-check that the input data in out2.Delta01 and out2.DestinationSum01 is as expected. Make sure they are valid numbers represented as strings. Check for null values: Ensure that there are no null values in out2.Delta01 or out2.DestinationSum01, as this can lead to unexpected results. You have already handled the case where out2.Delta01 is null in your expression, but it's important to confirm that both variables have non-null values for the division to work correctly. Debug the expression: Print or log the values of out2.Delta01 and out2.DestinationSum01 before performing the division to verify that they are indeed different for each variable. This will help identify if there's an issue with the assignment of values to the variables. Review the output columns: Ensure that the output columns for each variable are set correctly. It's possible that the values are being assigned to the same output column instead of separate ones, resulting in the same value for all variables. MyCCPay Login

Re: Tmap assigns the same value to different variables

AlSalvC — Wed, 07 Jun 2023 08:59:57 GMT

Hi, this is my tmap configuration. I believe this is set up correctly.

Re: Tmap assigns the same value to different variables

AlSalvC — Wed, 07 Jun 2023 09:00:27 GMT

this is the code

Re: Tmap assigns the same value to different variables

AlSalvC — Wed, 07 Jun 2023 09:01:13 GMT

same for Delta02

Re: Tmap assigns the same value to different variables

AlSalvC — Wed, 07 Jun 2023 09:12:44 GMT

I have already checked all of that. This are the values of the Sum, Delta and Rates.

Please find the code and tmap configuration that I used in the response to other comment. Thank you much for your help

Re: Tmap assigns the same value to different variables

AlSalvC — Thu, 08 Jun 2023 07:47:41 GMT

I replied to my own comment instead of replying to yours. Please find my response in the thread.