Default type of record in lookup fail

[prasson_ibm]

Hi,

I have source date as ID(Integer) nullable=No

I am doing lookup with reference column ID(Integer) and passing WEFF_DT(Timestamp,Microsecond) Nullable=No with lookup condition =Continue

For unmatched ID i am getting null in WEFF_DT which i need to handle.

I am applying below null handing in transformer:-

Code: Select all

if (isnull(EEFF_DT) or trim(WEFFDT)='') then '1999-12-31 00:00:00.0000000' else WEFFDT

But all records are getting dropped after transformer.

Please help me with null handling.

Thanks in advance.

[qt_ky]

Try this:

Code: Select all

If Trim(NullToEmpty(WEFFDT))='' Then ...

[kandyshandy]

Code: Select all

if (isnull(EEFF_DT) or trim(WEFFDT)='') then '1999-12-31 00:00:00.0000000' else WEFFDT

Did not this expression throw any error at the first place? At one spot EEFF_DT and WEFFDT at the other...

[prasson_ibm]

Code: Select all

if (isnull(EEFF_DT) or trim(WEFFDT)='') then '1999-12-31 00:00:00.0000000' else WEFFDT

Did not this expression throw any error at the first place? At one spot EEFF_DT and WEFFDT at the other...

Sorry there was a typo in the code.

[kandyshandy]

So the problem is resolved?