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?
MODIFY OPERATOR DROP
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 41
- Joined: Tue Jan 24, 2006 3:43 pm
- Location: United States
- Contact:
MODIFY OPERATOR DROP
Knowledge is Power
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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,
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,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 41
- Joined: Tue Jan 24, 2006 3:43 pm
- Location: United States
- Contact: