Querying a value within a data load

[#1]

I am looking for some Qlikview help.

I have loaded a QVD into memory (eg  called DATAX), one particular column in here has a list of XLS file names.

Separately I have a particular file name, that I have stored (as it is derived differently by checking folder contents)  eg $(vLatestXLS)

I want to check within the QVD data loaded memory (DATAX), if this $(vLatestXLS) already exists in there?

What command do I use to search the Datax while reloading the document?  I trying to use peek. Would this be the correct one?

Thanks

[Clever_Anjos]

Lookup() function maybe can help you

LookUp ‒ QlikView

[oscar_ortiz]

Are you simply trying to do something like this?

TempData:

Load

     YourColumn,

     YourColumn1,

     YourColumn2

Resident

     DATAX

Where

YourColumn = $(vLatestXLS)

;

Good Luck

Oscar