Can any one please suggest me on below expression in tmap component.
Scenario: I am trying to filter the records in tmap component using below expression, but unfortunately i am getting expression syntax error.
error message: Exception in thread "main" java.lang.Error: Unresolved compilation problem:
please suggest me on the above error.
You miss the row number in the expression "row.EMPNO==7839".
Should be "rowX" where "X" depends on your job design.
In case you just forgot "X" in the post, is EMPNO an integer?
Then if it's a String, replace the expression by the following if it makes sense:
or this one to convert EMPNO before the evaluation:
Integer.parseInt(rowX.EMPNO) == 7839
Hope this helps.
thanks for your input.
i tried with below approach but it didn't work.
In case you just forgot "X" in the post, is EMPNO an integer?--- Yes I forgot the X
is EMPNO an integer??--- No EMPNO is BigDecimal
tried the below expressions both:
Integer.ParseInt(row1.EMPNO)==7839...it didn't work
could you please look into it.
I tried with below given expression but it was giving an error BigInteger cannot be resolved.
So i tired using tConvertType component to convert my BigDecimal to Integer then filtered it. so it is working now.
please do let me know do you any documented related to all converstion types???
You need to import java.math.BigInteger first.
Google should help you to learn all about datatype conversion.
Don't forget to close the case for other people facing the same issue.
Kudos also accepted for the given time.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.