2 Replies Latest reply: Aug 19, 2011 1:26 PM by ahmedamm86 RSS

    How to add rows into existing fields?

      I have a table called Employee. It has the following load statement:

       

      LOAD DepartmentName,
      EmailAddress,
      EmergencyContactName,
      EmergencyContactPhone,
      EmployeeBusinessEntityID as SalesPersonID,
      EndDate as SalesPerson_EndDate,
      FirstName as SalesPerson_FirstName,
      LastName as SalesPerson_LastName,
      Title;
      SQL SELECT *
      FROM Employee;

       

      I would like to add 291 under the Field SalesPersonID, John as SalesPerson_FirstName, Adams as SalesPerson_LastName, and Sales Representative as the Title.

       

      Could anyone please help?