topic Re: Vlook like functions in QlikView

Vlook like functions

Wed, 08 Jan 2014 17:48:22 GMT

I have two tables and I want the data from table 1 only if a filed on table 1 matches with a field on table 2. Is this possible in Qlikview??

Re: Vlook like functions

MK_QSL — Wed, 08 Jan 2014 17:49:33 GMT

can you upload your sample file?

Re: Vlook like functions

preminqlik — Wed, 08 Jan 2014 17:53:52 GMT

table2:

load a1,

a2,

from xxx;

table1:

load t1,

t2,

from xxx3 where exists(a1,t1);

Re: Vlook like functions

CELAMBARASAN — Wed, 08 Jan 2014 18:14:39 GMT

Please have try like this

Table1:

Load

Field1,

Field2

From dataSource1;

INNER JOIN(Table1)

Load

Field1

From datasource2;

Re: Vlook like functions

MayilVahanan — Wed, 08 Jan 2014 18:50:38 GMT

Try like this

Table2:

Load

Field1,

Field2

From Table2;

Left JOIN(Table2)

Load

Field1

From Table1;

try with Exists() function

Re: Vlook like functions

Wed, 08 Jan 2014 19:04:38 GMT

Hi,

Applymap() is similar to vlookup in Excel, if thats what you are referring to. You can try that.

Thanks

Re: Vlook like functions

Wed, 08 Jan 2014 20:17:47 GMT

Hi Anitha,

On the load script side, the LookUp function works very much like the VLookUp funtion in Excel:

lookup(fieldname, matchfieldname, matchfieldvalue [, tablename])

From the Help file:

Example: lookup('Price', 'ProductID', InvoicedProd, 'pricelist')

Returns the value of fieldname corresponding to the first occurrence of the value matchfieldvalue in the field matchfieldname.

Fieldname, matchfieldname and tablename must be given as strings (e.g. quoted literals).

The search order is load order unless the table is the result of complex operations such as joins, in which case the order is not well defined.

Both fieldname and matchfieldname must be fields in the same table, specified by tablename. If tablename is omitted the current table is assumed.

If no match is found, null is returned.

HIH,

Charles