Failing to resolve Lookup_Ext Function issues in SAP BODS

[former_member530332]

suppose there are 3 records after the Lookup_Ext Function and also All the 3 records are matching the all the conditions ,

But i want only one record ,

Say there are one record with 'ID-1' , second record with 'ID-2' and third record with 'ID-3' , so i want record with 'ID-1 ' only ,

so How can i implement this scenario ?

[kalyani_kolli · Accepted solution]

Hi,

I think the below marked option with Return policy will use to achieve your scenario.

Hope it helpful..:)

Thanks,

Kalyani

[former_member530332 · Accepted solution]

Hi Kalyani , i am not sure but i think it is for Sorting , and my main motive is to show record with ID-1 only among these three IDs 1,2,3.

please brief me or correct me ?

[former_member208402]

Add one more condition in the lookup_ext and give Column='ID-1' or give condition in WHERE in Query.