How to insert rows into a table only if its primary keys exist in another table

[dei]

Hi all,

I'm new to Kettle and I need help on the Update step. I have a transformation which updates a table (TableA) and inserts selected fields into another table (Table B). My problem is, I only need to insert rows into TableB whose primary key exists in TableA. Is there a way to do that? If possible, all this should be in a single transformation.

I tried using Javascript for the conditions but I can't seem to make it all work. Please help! :(


Thanks,
Dei

[crafter]

Go ahead and do the lookup on table A (before UPDATE-ing, probably). The lookup step has an option "Do not pass the row idfthe lookup fails".

Will that not work for you?

[dei]

yes, that did the trick..
thanks very much for the help. :)