Drop when lookup key matches?
Posted: Wed Feb 18, 2015 9:53 am
We have searched, and been unable to find a thread referencing this.
We have two links out of transforms, going to a lookup. We specify a key column, and if that key matches in the lookup, we want to drop the record, and only send through rows that do not match. We have tried changing the parameters on the lookup, to no success. We ended up putting a transform after the lookup in order to drop those records that were not set to null (or space) in the lookup. Is there any way to do this in just the lookup stage?
We have two links out of transforms, going to a lookup. We specify a key column, and if that key matches in the lookup, we want to drop the record, and only send through rows that do not match. We have tried changing the parameters on the lookup, to no success. We ended up putting a transform after the lookup in order to drop those records that were not set to null (or space) in the lookup. Is there any way to do this in just the lookup stage?