topic Join two tables in QlikView

Join two tables

Anonymous — Tue, 31 Jan 2012 11:39:52 GMT

Hello evebody!

I've got a problem. I need to join two tables 'TableA' and 'TableB' on field 'FieldName'

[TableA]:

LOAD

FieldName,

Field1,

Field2

FROM

[$(vXLSDataDir)\FileNameA.xlsm]

(ooxml, embedded labels, table is [NameA]);

[TableB]:

LOAD

FieldName,

Field3,

Field4

FROM

[$(vXLSDataDir)\FileNameB.xlsm]

(ooxml, embedded labels, table is [NameB]);

I wrote next:

LEFT JOIN (TableA)

LOAD

FieldName,

Field3,

Field4

FROM

[$(vXLSDataDir)\FileNameB.xlsm]

(ooxml, embedded labels, table is [NameB])

WHERE _________________;

What i need to write in condition that make a join this tables?

Join two tables

CELAMBARASAN — Tue, 31 Jan 2012 11:43:29 GMT

Hi,

You don't need a condition if the field name is same.QlikView automatically join the tables based on the fieldname that is common.

Celambarasan

Join two tables

Anonymous — Tue, 31 Jan 2012 11:53:13 GMT

Thanks