Hiding specific columns
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 20
- Joined: Wed Nov 01, 2017 12:14 pm
Hiding specific columns
I have job that is gathering data on members of different locations within our corporation. For one location we do not need to have email field to show up. Is there a way to hide that field if the specific location is chosen from the list parameter before the job is run?
Respectfully,
Matt Johnson
Matt Johnson
-
- Participant
- Posts: 20
- Joined: Wed Nov 01, 2017 12:14 pm
Was hoping for a bit more information than that. By "seen" you mean not included in whatever your job is outputting, I assume, yes? And if that just means you want that column/field left empty/blank/null in the output, that should be pretty easy to accomplish. Leaving out the entire column could be another kettle of fish.
You should be able to setup a list parameter and based on which they choose, in the derivation for that output column you send spaces (or whatever) to that output column. Now, that will mean for every column in the list, you'll need to have a check in the matching column's derivation but they all will be very similar. Something like:
if #ListChoice# = <current column's name> then SPACES else <current value>
Hope that makes sense.
You should be able to setup a list parameter and based on which they choose, in the derivation for that output column you send spaces (or whatever) to that output column. Now, that will mean for every column in the list, you'll need to have a check in the matching column's derivation but they all will be very similar. Something like:
if #ListChoice# = <current column's name> then SPACES else <current value>
Hope that makes sense.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 20
- Joined: Wed Nov 01, 2017 12:14 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: