Hi, Having issues with table update. How do I add an out the process column value?

Matillion ETL
1

I have a target table which has 2 columns: Name and id.

I have the id I wish to update there but the name is fixed and I don't know how to update the table only having the updated id.

Trying table update, I create a new row with NULL name and the new id.

2

Hi, If any column is fixed you don't want to change you can take that column as default value and ignore that column in update component.​