aaparvez

Finding list value individually in another data table

Discussion created by aaparvez on Oct 19, 2015
Latest reply on Oct 19, 2015 by erolst

Purpose: I have a table containing list drug interaction like;

 

interaction REFERENCE TABLE

========================

--------------------------------------------------------------------------

Drug    /  Interaction Heading   / Interaction Message/

-------------------------------------------------------------------------------

ab

ba

ac

ca

ad

da

ae

ea

af

fa

ag

ga

ah

ha

ai

ia

aj

ja

ak

 

Now i have list of drugs. those are;

a

b

c

 

And i have produced a list by Custom function from List(Field) calculation that produced following list;

ab

ba

ac

ca

bc

cb

 

Now i want these pair to searched whether they are  present in REFERENCE TABLE or not. If present, then those matched pair or pairs should be shown with the "interaction message" value of the  REFERENCE TABLE.

I cannot figure out how to do that. Kindly need some expert advise to solve the problem. Thanks in advance.

Attachments

Outcomes