1 Reply Latest reply: Dec 5, 2017 7:52 PM by Sunny Talwar RSS

    setting priority to   n rows in a table and searching for same in  column/rows of another table based on this priority and return the one found first

    Vaibhav Tiwari

      Suppose i have 4 rows  as below:

      t1:

      Value ,priority

      Alpha,1

      Beta,4

      Gamma,2

      Zeta,3

      and it can contain n such values( so a dynamic script)

      I need to search this value in another table  colum  say t2:

      Data

      xyz...,

      vdhGamma..,

      dnjfj

       

       

      Like that

      and return alpha if it occurs first and then search for Gammma..

       

      Thanks !