topic [resolved] Getting equals cannot be resolved or is not a field Error in tmap? in Talend Studio

[resolved] Getting equals cannot be resolved or is not a field Error in tmap?

Anonymous — Tue, 13 Jan 2015 12:30:32 GMT

Hi all,
I add row1.internal.equals("y")?"Y":row1.internal in tmap. And
internal filed data type is character.When i run job i'm getting "equals cannot be resolved or is not a field" Error.
Thanks in Advance.
Regards,
Kumar.talend

Re: [resolved] Getting equals cannot be resolved or is not a field Error in tmap?

Anonymous — Tue, 13 Jan 2015 13:13:55 GMT

Hi Talend Kumar,
try this:

(row1.internal).equals("y")?"Y":row1.internal

MathurM

Re: [resolved] Getting equals cannot be resolved or is not a field Error in tmap?

Anonymous — Tue, 13 Jan 2015 13:14:59 GMT

check with this statement.

 row1.internal.equals('y')?'Y':row1.internal

Re: [resolved] Getting equals cannot be resolved or is not a field Error in tmap?

Anonymous — Tue, 13 Jan 2015 13:58:02 GMT

Thanks Umesh.
It's working fine.But i'm try to Replace null value in tmap it is not working.
row1.internal.equals(null)?'':row1.internal or row1.internal==null?'':row1.internal
Thanks,
kumar

Re: [resolved] Getting equals cannot be resolved or is not a field Error in tmap?

Anonymous — Tue, 13 Jan 2015 13:58:33 GMT

Looks like the variant without parenthesis and single quotes works

Re: [resolved] Getting equals cannot be resolved or is not a field Error in tmap?

Anonymous — Tue, 13 Jan 2015 14:04:22 GMT

Thanks Whitenorm,
Where should i remove parenthesis in logic?
Thanks,
kumar

Re: [resolved] Getting equals cannot be resolved or is not a field Error in tmap?

Anonymous — Tue, 13 Jan 2015 14:24:59 GMT

Try with this statement.

"null".equals(row1.internal) || row1.internal==null?' ':row1.internal

check once.

Re: [resolved] Getting equals cannot be resolved or is not a field Error in tmap?

Anonymous — Tue, 13 Jan 2015 14:39:30 GMT

Hi Umesh,
Thanks a lot.
It is working.Here i have 2 doubt.
1)If have remove "space" in single quotes,statement is not working(row1.internal==null?'':row1.internal)?
2) Why statement is working for single quotes( like row1.internal.equals('y')?'Y':row1.internal)
Not working for Double quotes(like row1.internal.equals("y")?"Y":row1.internal?
Thanks,
kumar

Re: [resolved] Getting equals cannot be resolved or is not a field Error in tmap?

Anonymous — Tue, 13 Jan 2015 14:57:13 GMT

your source and target data type is char which will expect char for comparing that is way double quotes not worked whereas single quotes worked.

Re: [resolved] Getting equals cannot be resolved or is not a field Error in tmap?

Anonymous — Wed, 14 Jan 2015 10:22:30 GMT

Thanks Umesh