Invalid argument types for function 'IFF': error

Matillion ETL
1

I am getting Invalid argument types for function 'IFF': error  when running Job.

 

It is updated date job from INC table to Main table

 

I am using Matillion for Snowflake .

 

Not able find where the issue happening. can some one please suggest

 

2

Unfortunately, I can't see all the details from your screenshot. Please have a look at the SQL which is generated by the Table Update component and post the SQL code here. This should indicate what's wrong here.

3

Seems like first Argument is returning number in IFF statement within SQL built.

Which should ideally return Boolean value (TRUE/FALSE).

 

Check for all conditions that have been setup.

4

Thanks, I found the issue.

 

It is because when I am updating from stage to main table I used variable which is not found hence I removed variable

0694G00000Rr0HSQAZ_0D74G000008yoPkSAI

and just used “Update”