topic Re: The operator! is undefined for the argument type int in Talend Studio

The operator! is undefined for the argument type int

Anonymous — Wed, 27 Mar 2019 06:33:27 GMT

Hi,

I want to use SCD1 in my job.so I have used tamp with the below condition

!Relational.isNull(row2.COURSE_KEY)
&&
(
!row1.STUDENT_ID.equals(row2.STUDENT_ID)||
!row1.EMAIL.equals(row2.EMAIL)||
!row1.ENROLLED_ON.equals(row2.ENROLLED_ON)|| !row1.GROUP_ID.equals(row2.GROUP_ID)||
!row1.IS_ENROLLED.equals(row2.IS_ENROLLED)|| !row1.LAST_SEEN_ON.equals(row2.LAST_SEEN_ON)|| !row1.LABELS.equals(row2.LABELS)||
!row1.NAME.equals(row2.NAME)||
!row1.USER_ID.equals(row2.USER_ID))

But iam getting

The operator ! is undefined for the argument type(s) Integer

Can you please help on this

Re: The operator! is undefined for the argument type int

manodwhb — Wed, 27 Mar 2019 06:47:26 GMT

@ruthvi , please try with the below one. can you tell me which column are coming with Integer type from input schema? change the comparison for the integer type. as changed for STUDENT_ID.

!Relational.isNull(row2.COURSE_KEY)
&&
(
row1.STUDENT_ID<>row2.STUDENT_ID||
!row1.EMAIL.equals(row2.EMAIL)||
!row1.ENROLLED_ON.equals(row2.ENROLLED_ON)|| !row1.GROUP_ID.equals(row2.GROUP_ID)||
!row1.IS_ENROLLED.equals(row2.IS_ENROLLED)|| !row1.LAST_SEEN_ON.equals(row2.LAST_SEEN_ON)|| !row1.LABELS.equals(row2.LABELS)||
!row1.NAME.equals(row2.NAME)||
!row1.USER_ID.equals(row2.USER_ID))