# Invalid argument types for function 'IFF': error

**URL:** <https://matillioncommunity.discourse.group/t/invalid-argument-types-for-function-iff-error/2110>\
**Category:** Matillion ETL\
**Created:** [March 27, 2023, 3:44am UTC](https://matillioncommunity.discourse.group/t/invalid-argument-types-for-function-iff-error/2110 "2023-03-27T03:44:52Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![satya.dachavaram](https://avatars.discourse-cdn.com/v4/letter/s/b9e5f3/32.png) [@satya.dachavaram](https://matillioncommunity.discourse.group/u/satya.dachavaram)\
**Post date:** [March 27, 2023, 3:44am UTC](https://matillioncommunity.discourse.group/t/invalid-argument-types-for-function-iff-error/2110/1 "2023-03-27T03:44:52Z")

</div>

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

&nbsp;

It is updated date job from INC table to Main table

&nbsp;

I am using Matillion for Snowflake .

&nbsp;

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

&nbsp;

---

<div class="post-metadata">

**Author:** ![Michael](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@Michael](https://matillioncommunity.discourse.group/u/Michael)\
**Post date:** [April 4, 2023, 12:30pm UTC](https://matillioncommunity.discourse.group/t/invalid-argument-types-for-function-iff-error/2110/2 "2023-04-04T12:30:41Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![ASD](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/asd/32/1323_2.png) [@ASD](https://matillioncommunity.discourse.group/u/ASD)\
**Post date:** [April 12, 2023, 4:44pm UTC](https://matillioncommunity.discourse.group/t/invalid-argument-types-for-function-iff-error/2110/3 "2023-04-12T16:44:35Z")

</div>

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

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

&nbsp;

Check for all conditions that have been setup.

---

<div class="post-metadata">

**Author:** ![satya.dachavaram](https://avatars.discourse-cdn.com/v4/letter/s/b9e5f3/32.png) [@satya.dachavaram](https://matillioncommunity.discourse.group/u/satya.dachavaram)\
**Post date:** [April 20, 2023, 1:37am UTC](https://matillioncommunity.discourse.group/t/invalid-argument-types-for-function-iff-error/2110/4 "2023-04-20T01:37:07Z")

</div>

Thanks, I found the issue.

&nbsp;

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](https://us1.discourse-cdn.com/flex002/uploads/matillioncommunity/optimized/1X/8725b0b22aad57c6d9208e13d04d1ebf061ef2ef_2_690x56.jpeg)

and just used “Update”