Can someone help me with a derivation to be written in tfm stage to pass value '_' if any value exists in column A and value '/' if no value exists in column A.
Derivation
Moderators: chulett, rschirm, roy
Let's assume Parallel and get your post into the correct forum. Starting off life in the FAQ Discussion forum wasn't it.
Cutty Mark, can you go back and edit your post to include the details the original forum didn't force you to include - O/S, Job Type, Version? Thanks.
Cutty Mark, can you go back and edit your post to include the details the original forum didn't force you to include - O/S, Job Type, Version? Thanks.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
The transform stage for server and parallel jobs will have the same syntax for this column derivation
Code: Select all
IF (TRIM(InputLink.Column_A)='') THEN '/' ELSE '_'
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
... with just a little added complexity if your definition of "does not have a value" includes the possibility of NULL.
Code: Select all
If IsNull(InputLink.Column_A) Or (Trim(InputLink.Column_A) <= ' ') Then '/' Else '_'
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 8
- Joined: Wed Sep 30, 2015 2:39 am
-
- Participant
- Posts: 8
- Joined: Wed Sep 30, 2015 2:39 am
Yep. . . This is what I too tried. However, it was mentioned as 'If value doesn't exist in colomn(column_name)' . . .ray.wurlod wrote:... with just a little added complexity if your definition of "does not have a value" includes the possibility of NULL.
So am not sure what they mean.
So waiting for the response from business side.
Thanku
Never Quit