lookupstage issue

[ntr]

Hi ,
In lookup stage i am facing an issue
My job

Code: Select all

src->trans->lkp->trans->db
             |  
   File---->trans

src input:
A,B,C
1,AA,23
,BB,24
File:
A,B
1,AA
,BB

I am using lookup
Before lookup i am using NulltoValue((A),'Null')from source

But it was not working can any one guide on this

[Kirtikumar]

First thing - Close the other duplicate post. Second thing - when providing some job design or code and alignment is needed use the code button provided above and using the preview button make sure it looks the way you want it.

Now coming to your problem - is there any warning or error in the job logs? Not working means - job is failing, or you are not getting the output?

[chulett]

First thing - Close the other duplicate post. Second thing - when providing some job design or code and alignment is needed use the code button provided above and using the preview button make sure it looks the way you want it.

Done and done.

[ray.wurlod]

So what's the issue?