topic Re: Problem with tFilterRow component TOS_DI 7.1.1 in Talend Studio

Problem with tFilterRow component TOS_DI 7.1.1

Anonymous — Thu, 04 Apr 2019 11:00:59 GMT

Hello, before starting sorry for my level in English.

I have a problem when I use the advanced mode of the tFilterRow component. I want to retrieve the value of the NAME field by doing this: input_row.NAME.equals ("My_Value")

But I still get this error that is on the picture.

I'm using Talend Open Studio for Data Integration version 7.
Help please

Re: Problem with tFilterRow component TOS_DI 7.1.1

David_Beaty — Thu, 04 Apr 2019 11:15:01 GMT

Hi,

Are you sure you're not using columnName2 in the expression? Thats the example it gives you when you enable Advanced Mode - try enabling advanced mode and ensure nothing is there.

Re: Problem with tFilterRow component TOS_DI 7.1.1

Anonymous — Thu, 04 Apr 2019 11:23:55 GMT

Hello David,

Thank you for your answer but columnName2 is not used. I tried to create a new job with another data set but the problem is the same. I am blocked..

Re: Problem with tFilterRow component TOS_DI 7.1.1

manodwhb — Thu, 04 Apr 2019 11:31:17 GMT

@Guen ,can you show your job design with all the component settings?

Re: Problem with tFilterRow component TOS_DI 7.1.1

joearun4u — Thu, 04 Apr 2019 11:34:14 GMT

Hi Guen,

I have faced the same issue couple of times in TOS. My job keep failing due to variable which is not used in my current job. The job may be stuck due to frequently trying out different options for any solution.

What I did is , I just closed the project in TOS, and created a new Job with the same data flow (Not copying the components from the previous job ) and executed, It worked. You can try the same and let us know if you face the same issue again.

Thanks,

Joe

Re: Problem with tFilterRow component TOS_DI 7.1.1

Anonymous — Thu, 04 Apr 2019 14:07:53 GMT

Hello Joe,

I did as you told me but it has not changed. I always have this error.

@manodwhb here is my job and the tFileInputDelemited schema.

Re: Problem with tFilterRow component TOS_DI 7.1.1

Anonymous — Thu, 04 Apr 2019 14:13:06 GMT

What is amazing is that this problem persists when I activate the advanced mode while putting the condition code in comment

Re: Problem with tFilterRow component TOS_DI 7.1.1

David_Beaty — Thu, 04 Apr 2019 14:21:49 GMT

Can you include the component configuration of the tFilterRow component - ensure the Advanced Mode is ticked (even if you're not using it).

Thanks

Re: Problem with tFilterRow component TOS_DI 7.1.1

Anonymous — Thu, 04 Apr 2019 14:36:37 GMT

Hello everyone,

Finally the problem is solved. I restarted my machine and created a new project.

Thank you David, Joe, Manohar and other members of this community.

Guen

Re: Problem with tFilterRow component TOS_DI 7.1.1

akumar2301 — Thu, 04 Apr 2019 14:42:52 GMT

Can you please check Code Tab , in that you must have an error(red mark at right has side). click on that

[at line no 1426 ( as mentioned in 1st )screenshot]

Can you give up the screenshot of that? also try to do Java debug instead. That would give more idea.