Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problem with tFilterRow component TOS_DI 7.1.1

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
0683p000009M3PT.png

Labels (2)
1 Solution

Accepted Solutions
joearun4u
Creator
Creator

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

 

<Give kudos if you find this tip is useful>

View solution in original post

9 Replies
David_Beaty
Specialist
Specialist

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.

 

Anonymous
Not applicable
Author

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

manodwhb
Champion II
Champion II

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

joearun4u
Creator
Creator

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

 

<Give kudos if you find this tip is useful>

Anonymous
Not applicable
Author

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.

0683p000009M3G6.png0683p000009M3WT.png

Anonymous
Not applicable
Author

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

David_Beaty
Specialist
Specialist

Hi

 

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

 

Thanks

Anonymous
Not applicable
Author

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

akumar2301
Specialist II
Specialist II

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.