DSXchange

Posted: **Thu Feb 23, 2012 8:51 am**

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.

Posted: **Thu Feb 23, 2012 6:07 pm**

Try this:

Code: Select all

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

Posted: **Thu Feb 23, 2012 8:47 pm**

prasson_ibm wrote:

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

Posted: **Fri Feb 24, 2012 12:53 am**

kandyshandy wrote:
prasson_ibm wrote:
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.

Posted: **Fri Feb 24, 2012 1:11 am**

So the problem is resolved?

DSXchange

Default type of record in lookup fail

Default type of record in lookup fail

Re: Default type of record in lookup fail

Re: Default type of record in lookup fail