How to add rows into existing fields?

[#1]

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?

[Jason_Michaelides · Accepted solution]

Under your load script above:

Concatenate (Employee)

Load * Inline [

SalesPersonID,SalesPerson_FirstName,SalesPerson_LastName,Title

291,John,Adams,Sales representative

];

Jason

[#3]

i created an excel sheet and concatenated it. But thanks for your input...