Derivation

Cutty Mark · Post by **Cutty Mark** » Wed Sep 30, 2015 2:56 am

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.

rkashyap · Post by **rkashyap** » Wed Sep 30, 2015 6:23 am

Parallel or Server job?

Assuming parallel job, see examples of null handling functions in Parallel transformer in this link. Also see this post.

chulett · Post by **chulett** » Wed Sep 30, 2015 7:14 am

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.

ArndW · Post by **ArndW** » Wed Sep 30, 2015 9:16 am

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 '_'

ray.wurlod · Post by **ray.wurlod** » Wed Sep 30, 2015 4:42 pm

... 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 '_'

Cutty Mark · Post by **Cutty Mark** » Thu Oct 01, 2015 1:32 am

Thanku rkashyap. . .

I used IsNull() and solved it.
Its working fine

Cutty Mark · Post by **Cutty Mark** » Thu Oct 01, 2015 1:40 am

ray.wurlod wrote:... with just a little added complexity if your definition of "does not have a value" includes the possibility of NULL.

Yep. . . This is what I too tried. However, it was mentioned as 'If value doesn't exist in colomn(column_name)' . . .

So am not sure what they mean.

So waiting for the response from business side.

Thanku

DSXchange

Derivation

Derivation

Reply