Skip to Content
Oct 23, 2012 at 05:08 AM

Table Comparison with updating status flag


Hi All,

I am trying to compare two tables by using Table comparison transform.

Now my requirement is, i want to compare two tables and update my one of table with only a flag say ''Y'' if i found a match in the target table.

But when i use table comparison transform it directly Updates my target table or it inserts a new record if that record is not available.

Can i get some way out ,that after comparison it returns me just a flag value so that i can update my target table with that flag and if that record does not exists

in my target table then i will insert in target table.

I tried putting validation rule after table comparison transform but it didn't worked.

So any other way to do the above scenario.