MODIFY OPERATOR DROP

pratapsriram · Post by **pratapsriram** » Thu Feb 16, 2012 4:22 pm

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?

ray.wurlod · Post by **ray.wurlod** » Thu Feb 16, 2012 4:40 pm

No.

But you only have to do it once.

jwiles · Post by **jwiles** » Thu Feb 16, 2012 4:41 pm

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,

ray.wurlod · Post by **ray.wurlod** » Thu Feb 16, 2012 4:51 pm

Just to confirm, you only get one DROP specification. Or only one KEEP specification. Not both.

pratapsriram · Post by **pratapsriram** » Fri Feb 17, 2012 7:58 am

Can't I have Drop Column1;
Drop Column2;
Drop Column3;
.
.
.
Drop ColumnN;

chulett · Post by **chulett** » Fri Feb 17, 2012 8:02 am

Just to confirm... no.