Vlook like functions

[#1]

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??

[MK_QSL]

can you upload your sample file?

[preminqlik]

table2:

load a1,

a2,

a3

from xxx;

table1:

load t1,

t2,

t3

from xxx3 where exists(a1,t1);

[CELAMBARASAN]

Please have try like this

Table1:

Load

     Field1,

     Field2

From dataSource1;

INNER JOIN(Table1)

Load

         Field1

From datasource2;

[MayilVahanan]

Hi

Try like this

Table2:

Load

     Field1,

     Field2

From Table2;

Left JOIN(Table2)

Load

         Field1

From Table1;

or

try with Exists() function

[#6]

Hi,

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

Thanks

AJ

[#7]

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