I have the scenario (using a third party component) where certain columns must not be present as input.
I am doing a Full Outer - Merge Join.
This results in:
but now in some cases the LeftPK may be null in other cases the RightPK may be null,
so i'm creating a derived column to check:
ISNULL(LeftPK) ? RightPK : LeftPK
and call this the TruePK
this all works however now i'm left with 3 columns
LeftPK; RightPK; TruePK
Is there some kind of transform (other than script task) that i can use to get rid of Left and Right PK columns before sending input to next third party component?
View Complete Post