Hash file Look up

[kollurianu]

Hi All,

Code: Select all

Input1 ---->  T1  ---->  HF 
                                  | 
                                  V 
Input2  ----------------> T2  ------> Target

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 '

[pnchowdary]

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.

[Sainath.Srinivasan]

You can say

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

[kollurianu]

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