Clovertech

Multiple values for Table Lookup

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › Multiple values for Table Lookup

  • Creator
    Topic
  • October 21, 2008 at 10:26 pm #50402
    Scott Smith
    Participant

      Is it possible to send multiple variables for a table lookup?  I am performing via tcl.  Here is an example of what i am asking:

      tbllookup variable1 variable2

    • Creator
      Topic
    Viewing 4 reply threads
    • Author
      Replies
      • October 22, 2008 at 11:25 am #65988
        Alice Kazin
        Participant

          I concatenate the 2 variables and use them for the table

          For example:

          ABC001

          ABC002

          DEF001

          DEF002

        • October 22, 2008 at 1:56 pm #65989
          James Cobane
          Participant

            Scott,

            Are you asking if you can perform a table lookup for each of the values supplied and if any are found, do something?

          • October 22, 2008 at 2:04 pm #65990
            Scott Smith
            Participant

              Actually I want to search a table with values from OBR 16 and OBR 28.  these values might not be the same.

            • October 22, 2008 at 3:54 pm #65991
              James Cobane
              Participant

                Do both values have to be ‘found’ or is it if ‘either one’ is found?  Either way, you can simply perfom the table lookup twice, and check to see if either (or both) were found.

                Jim Cobane

                Henry Ford Health

              • October 30, 2008 at 4:42 pm #65992
                Bala Pisupati
                Participant

                  I agree with Jim, we have a similar situation where we need to check OBR4 and OBR19 and we have two seperate tables for each.

              • Author
                Replies
              Viewing 4 reply threads
              • The forum ‘Cloverleaf’ is closed to new topics and replies.