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
My Final table should have BankID which is present on TeamList Table
