Page 1 of 1
MODIFY OPERATOR DROP
Posted: Thu Feb 16, 2012 4:22 pm
by pratapsriram
Is there a shortcut to DROP multiple columns.
Like if we want to drop column number 100 to 120 from the input link. Is there some notation we can do for that in Modify Operator?
Posted: Thu Feb 16, 2012 4:40 pm
by ray.wurlod
No.
But you only have to do it once.
Posted: Thu Feb 16, 2012 4:41 pm
by jwiles
No shortcut, other than specifying multiple columns in a single drop specification:
DROP A,B,C,D,E,F and so on
Same for KEEP. The column "numbers" in the stage column grids in Designer mean nothing to the operators themselves. They strictly use the column names.
Regards,
Posted: Thu Feb 16, 2012 4:51 pm
by ray.wurlod
Just to confirm, you only get one DROP specification. Or only one KEEP specification. Not both.
Posted: Fri Feb 17, 2012 7:58 am
by pratapsriram
Can't I have Drop Column1;
Drop Column2;
Drop Column3;
.
.
.
Drop ColumnN;
Posted: Fri Feb 17, 2012 8:02 am
by chulett
Just to confirm... no.