Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

vaibhav11
New Contributor

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

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 !

1 Reply

Re: 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