How to reject the records

sujaoschin · Post by **sujaoschin** » Fri Aug 22, 2008 1:51 am

I have a column "AS_LOCATION' which has value of 101,111,105 and D. I need to reject the records with value 'D' and populate the rest into target table.

Please advise.

ray.wurlod · Post by **ray.wurlod** » Fri Aug 22, 2008 2:32 am

Constraint expressions.
InLink.AS_LOCATION <> "D" (regular output)
InLink.AS_LOCATION = "D" (reject link)

chulett · Post by **chulett** » Fri Aug 22, 2008 6:58 am

Please don't start a new post for something you've already asked about:

viewtopic.php?p=297394

You should have just asked for a clarification there.

sujaoschin · Post by **sujaoschin** » Mon Aug 25, 2008 12:08 am

Thanks , Ray. The problem is resolved.

As mentioned by you, I used the constraint expressions like below

Constraint expressions.
InLink.AS_LOCATION <> "D" (regular output)
InLink.AS_LOCATION = "D" (reject link)