Where exists

[#1]

Hi

I have to load 3 tables based on the below table

TeamList:

LOAD [Emp ID] as BankID,

     Name,

     DOJ,

     [Supervisor Name]

From

....................................\TeamList.xls;

Attendance:

LOAD

       "[Bank ID]" ,

     "[Staff Name]" as [Staff Name],

     "[Log Type]" as  [Log Type],

FROM

........................Attendance.qvd

(qvd);

Concatenate

Training:

LOAD

[Bank ID] ,

[Staff Name],

LOAD Date,

     Team,

     [Bank ID],

     [Staff Name]

FROM

................\Meeting.qvd

(qvd);

Concatenate

Meeting:

LOAD

Date

[Bank ID] ,

[Staff Name],

Group By Date, [Bank ID], [Staff Name];

LOAD Date,

     Team,

     [Bank ID],

     [Staff Name]

FROM

.................\Meeting.qvd

(qvd);

Based on the [Emp ID]  in TeamList Table , i have to load all the other 3 tables and concatenate..

How do i achieve it

[MK_QSL]

Use Where Exists(BankID, [Bank ID]);

[#3]

Hi

There are 3 tables named

Attendance,

Meeting,

Training

They are concatenated

My final Concatenated table should have BankID which are present only in TeamList