In the table fields should be updated but should not be inserted?

[Ramanjaneyuv]

In the table fields should be updated but should not be inserted ?

Scenario:1. we are importing data through import set , 

2, here fields should be updated but should not insert new rows in the Tables.

Thanks

Ram

[Dr Atul G- LNG]

Hi @Ramanjaneyuv 

Use the coalsec.

https://youtu.be/6dU9yBQPq_I

[Ramanjaneyuv]

Thanks for your response @Dr Atul G- LNG ..

Here my point 1. Records should be updated  otherwise records will bet insert in the table (coalsec) .

2. my question is records should be updated but records should not be inserted or  new rows in the table.

Thanks

[Dr Atul G- LNG]

Hi @Ramanjaneyuv 

Its decided by coalsec. If coalsec match it will update else insert the record.

[luffy3478]

in on before transform script

if (action == "insert") ignore = true;