topic Re: Testing expression in Talend Studio

Testing expression

Anonymous — Sun, 10 Nov 2019 11:37:14 GMT

Hi,

I am trying to do a simple task with Talend Open Studio for Data Integration.

Added a simple excel file (AAA_in) with a few columns (AAA, BBB, CCC), and I would like to know

in the column (CCC) value is empty or not. If it is empty/not empty, CCC_boolean - true/false.

I would like to see this information in XML out (AAA_out)

Added expression AAA_in.CCC.equals("") and I should see CCC_boolean is true or false.

When I testing expression, it works.

But actually, when I running a job and data in the column is empty, Talend stops on this line without any xml results.

Could you please help with this simple task.

Thank you!

Best Regards,

Erlandas

Re: Testing expression

Anonymous — Mon, 11 Nov 2019 02:58:48 GMT

First, make sure the value is empty string or null value, or you can use this express whatever it is empty or null value, for example, on a tMap, set the expression on the CCC
(row1.CCC==null||row1.CCC.equals(""))?true:false

If you still have the issues, please provides more details.

Regards
Shong

Re: Testing expression

Anonymous — Mon, 11 Nov 2019 07:45:12 GMT

Hi,

Yes, thank you very much, it works!

One more question, please.

How can I check column rows?

If the column rows values are equal, mark these rows as true.

Something like this in CCC, we can see C335 and C335 equals

and I would like to add boolean true.

AAA	BBB	CCC	DDD
A111	B222	C333	D444	FALSE
A112	B223	C335	D445	TRUE
A113	B224	C335	D446	TRUE

Thank you very much for your help

Best Regards,

Erlandas

Re: Testing expression

Anonymous — Mon, 11 Nov 2019 09:43:26 GMT

I think you need to get the duplicated values using tUniqueRow component, and then do an left outer join between input data and duplicated values on a tMap.

Re: Testing expression

Anonymous — Mon, 11 Nov 2019 10:10:17 GMT

Hi,

Not sure where to connect tUniqueRow component.

Could you please give me more details on how to do it.

Maybe you can give an example.

Many thanks

Erlandas

Re: Testing expression

Anonymous — Mon, 18 Nov 2019 13:15:55 GMT

Hi,

I found how this can be done.

Thank you for your help.

Regards,

Erlandas