2 Replies Latest reply: Jul 16, 2015 2:38 PM by Senthil Kumar RSS

    Where exists

      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