Checking the data existance in Database

[kettle_anonymous]

Is there anyway we can check if the data is already existing in the table where it is going to be inserted

[MattCasters]

Yes, use the Insert/Update step, it only inserts when the key can't be found.
It only updates when needed.

Hope this help,

Matt

[kettle_anonymous]

Hi Matt,
Thanks for your reply.But my requirement is that if the data already exists in the table it should skip that particular record and proceed with the next Record.
Rgds,
Kasi

[MattCasters]

Well then I guess you need to do a lookup then and check if the returned key value is null or not.
- DB Lookup
- Filter
- Insert

[kettle_anonymous]

Hi Matt,
Is it possible to create a step like Insert/Update without the update ????

Regards,
Samatar

[MattCasters]

Dude, use a table output!

RTFM I guess ;-)

Cheers,
Matt

[kettle_anonymous]

Ummm... How is this not done by the Insert/Update step? The way I see the Insert/Update step working is this:

1. Check if the record exists - if not, then insert record.
2. If record exists, then update if record contains new information.
3. Otherwise, do nothing.

Is this interpretation correct?

[MattCasters]

Yes, that interpretation is correct.

The insert/update step has been changed in the mean time to have an insert/update WITHOUT the update, using a flag...

HTH,
Matt