Formula to Get duplicate values

HCL Domino Domino Forum
1

Dear All,I have 2 dblookups in 2 computed fields say dblookup1 and dblookup2.

i have a,b,c in dblookup1

and

a,b,e,n in dblookup2

i need to display a.b (duplicate values) in a another field…how can i do this

thanks

shana

2

Subject: formula to Get duplicate values

Try this:@Keywords(dblookup1; dblookup2)

Konrad

3

Subject: RE: formula to Get duplicate values

Thanks…this is what i wrote but it doesn’t give the correct answer…Key1 := @Text(PL_Loc);

vresult1 := @DbLookup(“”:“NoCache”;“”:“”; “GetSA_Branch_Hdn_View”;Key1;2);

Key2 := @Text(PL_Cat);

vresult2 :=@DbLookup(“”:“NoCache”;“”:“”; “Get_SA_Cat_Hdn”;Key2;2);

vresult :=@Keywords(vresult2;vresult1);

@If(!@IsError(vresult);“”:vresult; " " )

4

Subject: RE: formula to Get duplicate values

will you pls send the error. this should work . for more call me on ajitnarayan123@gmail.com

5

Subject: RE: formula to Get duplicate values

What do You mean not correct answer? Is result an empty string or an incorrect values?

I made test:

vresult1 := “aa”:“bb”:“cc”:“dd”;

vresult2 :=“11”:“22”:“bb”:“333”:“cc”:“44”;

vresult :=@Keywords(vresult2;vresult1);

@If(!@IsError(vresult);“”:vresult; " " )

and formula returns:

, bb, cc

so everything is OK.

Check vresult1 and vresult2 values - are they OK?

Konrad

6

Subject: RE: formula to Get duplicate values

Thanks …yes i checked both values…i put vresult2 and vresult1 to 2 comboboxes and got correct output and the put another combo with the formularvresult :=“”:@Keywords(vresult2;vresult1);

vresult

it gives only one value

if i have

vresult2=a b c d e f

vresult1 = a b

for vresult i got only b…

7

Subject: RE: formula to Get duplicate values

What types of fields do You use (combobox, dialoglist, checkbox, etc.)?Combobox in LN is a single value type field…

Konrad

8

Subject: RE: formula to Get duplicate values

i’m using it in combo box…selection formulai managed to do that with @Replace and got the correct answer…here’s the formula…will it be okay pls confirm me

Key1 := @Text(PL_Loc);

vresult1 := “”: @DbLookup(“”:“NoCache”;“”:“”; “GetSA_Branch_Hdn_View”;Key1;2);

Key2 := @Text(PL_Cat);

vresult2 := “”: @DbLookup(“”:“NoCache”;“”:“”; “Get_SA_Cat_Hdn”;Key2;2);

vresult :=@Replace(vresult2;vresult1;vresult1:vresult2);

@If(!@IsError(vresult); vResult; “” )

9

Subject: RE: formula to Get duplicate values

I don’t think it is correct.If there is value in vresult2 which is not in vresult1 it will be returned - look in DD help for @Replace example.

Konrad