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

[vaibhav11]

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 !

[sunny_talwar]

May be using MapSubstring - script function ‒ QlikView