Lookup condition

[today]

Hi,
I have tried various logocs,but all in vein.I am sure one of you gurus can really help me out.

I want to implement a lookup in the transformer,which if met, should not bring that rows in the hashed file.


IsNull(lkp_CRC.CRC) or CRC <> lkp_CRC.CRC
OR
IsNull(lkp_CRC1.CRC) or CRC <> lkp_CRC1.CRC

I also tried

IsNull(lkp_CRC.CRC) or CRC or IsNull(lkp_CRC1.CRC) <> lkp_CRC.CRC or lkp_CRC1.CRC

Am i doing something wrong?

When I use just one condition its working fine , but not with both conditions on.

Please help

Thanks in advance.

[today]

I am trying to implement this in constraint

[chulett]

Your first syntax is fine unless both sides could be null. Simpler to use the NullToEmpty() transform, perhaps on both sides:

NullToEmpty(lkp_CRC.CRC) <> NullToEmpty(CRC)

[today]

I tried

NullToEmpty(lkp_CRC.CRC) or NullToEmpty(CRC) <> NullToEmpty(lkp_CRC.CRC)
OR
NullToEmpty(lkp_CRC1.CRC) or NullToEmpty(CRC) <> NullToEmpty(lkp_CRC1.CRC)

but its not working too

[JRodriguez]

(
IsNull(lkp_CRC.CRC) or ( NullToEmpty(CRC) <> NullToEmpty (lkp_CRC.CRC) )
)

OR
(
IsNull(lkp_CRC1.CRC) or (NullToEmpty(CRC) <> NullToEmpty(lkp_CRC1.CRC) )

)

[today]

It worked just fine

Thanks a lot guys

[chulett]

Just for the record, you don't need the extra "IsNull" check with the NullToEmpty transform on both sides.