DSXchange

Hi All,
I would need some help in the above design iam joining the hash file

with dunsnumber from input1 and input2 , i need a expression in
target field(Transaction Code) value as 'N' , when i donot find dunsnumber from input2 in input1.

Is it possible , if so how can i do that?

Can i say IsNull(input1.dunsnumber) then 'N';

Any help greatly appreciated.

Thank you all '

Hi Anu,

If I understand your question correct.

When your lookup field value (Input2) is not found in your input (Input1). You want to populate a target field with "N"

To achieve this you can use the link variable "INPUT2.NOTFOUND" and use this as a condition to populate your target field with "N"

Hope that helps.

You can say

If IsNULL(Col) Then 'N' Else 'Y'

Thank you all for ur answers , i would try ur suggestions.