Rejecting data in a tmap/ using thashoutput

[JayZ1]

I am bringing in data from one database to another however my source data is never going to remove old entries, and I do not want to continue to bring older entries I have already brought in. Tdbinput_1 brings in the data, TdbInput2 compares the data im bringing in to the data that is in the new table itself, I want to keep a few fields as is and not update them with null entries for example if a column description has QA, the source has this column as null so I use tdbinput2 to keep the value QA. Now another thing I have to do is compare the data I'm bringing in to an ARCHIVE table which is tdbinput_3. I have a unique value 'number' here that I am using throughout all the tables, so basically if number '123' exists in tdbinput3 I do not want to bring it in from tdbinput1. I was thinking I could dump the ARCHIVE table into a thashoutput and use that to reject those values but a simple tfilterrow would not be able to read values from a tashoutput to reject. Unless it would? any recommendations on how to do this?

[Anonymous]

tHashOutput is used to cache the data into memory, we usually use it to cache small data sets so that we can use it multiple times when needed. In you case, if you only use the data from tDBInput_3 one time, you don't need to cache the data using tHashOutput.

What is the 'action on data' option on tDBOutput_1? If the 'Die on error' box is unchecked, the duplicated records will be rejected when doing 'insert' action.

Regards

Shong