2 Replies Latest reply: Oct 5, 2018 6:49 AM by lakshminarayanan jaganathan RSS

    Need to combine the two table to get the Sales person details according to EMP id

    lakshminarayanan jaganathan

      Hi ALL,

      I need combine the two table and need to display the data based on sales person ,Please find the table details below

      2014:

      LOAD

          EmployeeID as EMPID%,

          SalesPerson,

          "Year",----->Contain only 2014 year

          Quater,---->Contain Q1,Q2,Q3,Q4

          Sales

      FROM [lib://source/Quota.qvd]

      (qvd);

       

      2015:

      Load * Resident 2014;

      LOAD

          EmployeeID as [EMPID%],

          "Year",---->2015 as year

          Quater ,---->Contain Q1,Q2,Q3,Q4

          Sales

      FROM [lib://source/Quota1.qvd]

      (qvd);

      Drop Table 2014;

       

      in 2014 table it is having sales Person name related to the EMPID and i need  the same in 2015 to display the sales person name,

       

      Kindly let me know how we can achieve.