1 Reply Latest reply on Oct 19, 2015 10:31 AM by erolst

    Finding list value individually in another data table

    aaparvez

      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.