Query in the transformer

Immaculin · Post by **Immaculin** » Mon Aug 13, 2007 2:04 am

Hi

If ((IsNull(DSLink2.DUNS_LEVEL_1) =0) And (IsNull (DSLink2.DUNS_LEVEL_2) = 0) And (IsNull( DSLink2.DUNS_LEVEL_3) =1)) Then DSLink2.LEGACY_CD Else DSLink2.DUNS_LEVEL_3 .
In the above query it checks that if my first level is not null and my second level is not null and my third level is null, it populates the required field in the third level. Is the above query right?. for eg

level1 level2 level3
1234 2545 null

then output should be

level1 level2 level3
1234 2545 7894 if dslink.legacy_cd=7894.

thanks

bcarlson · Post by **bcarlson** » Mon Aug 13, 2007 10:24 am

Duplicated topic. Poster, please remove.

Brad.

chulett · Post by **chulett** » Mon Aug 13, 2007 10:32 am

Brad, once you reply to it it can no longer be removed. At least not by the OP.

bcarlson · Post by **bcarlson** » Mon Aug 13, 2007 10:52 am

"Poster (not OP), please remove"

bcarlson · Post by **bcarlson** » Mon Aug 13, 2007 10:54 am

Okay, I haven't had enough coffee yet. Does OP mean 'original poster' or something else?

If 'OP == original poster'
then

Ooops
else

ok
end-if

Brad.

chulett · Post by **chulett** » Mon Aug 13, 2007 11:08 am

OP = Original Poster = Oops.