I need to lookup a key and insert record if it does not exist. The record should not be updated if the key exists. Is there a component I can use (I cannot use the Table Update because the data gets updated if the key exists)
2 Community Answers
Kalyan Arangam —
You may use the EXCEPT transformation component to compare your incoming(primary) dataset with the existing (comparing) table.