Join two tables

[Anonymous]

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?

[CELAMBARASAN · Accepted solution]

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

[Anonymous]

Thanks