Is it possible to have a transformation script component which filters rows as well as adding new output columns?
I have a script component with "Output 0":
- Exclusion Group = 1
- SynchronousInputID = Script Component.Inputs[Input 0]
- 2 x additional columns
In my code I have:
Row.newcol1 = "Value 1";
Row.newcol2 = "Value 2";
if (Row.oldcol1.Length <= 20)
{
Row.DirectRowToOutput0();
}
But I'm getting the errors:
CS0229 Ambiguity between 'Input0Buffer.newcol1' and 'Input0Buffer.newcol1'
CS0229 Ambiguity between 'Input0Buffer.newcol2' and 'Input0Buffer.newcol2'
So I can filter rows *without* adding new columns and I can add new columns *without* filtering data.
Is there a way to add columns *and* filter data without having to create a new set of output columns and copying over the inputs to the outputs?