Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Under your load script above:
Concatenate (Employee)
Load * Inline [
SalesPersonID,SalesPerson_FirstName,SalesPerson_LastName,Title
291,John,Adams,Sales representative
];
Jason
Under your load script above:
Concatenate (Employee)
Load * Inline [
SalesPersonID,SalesPerson_FirstName,SalesPerson_LastName,Title
291,John,Adams,Sales representative
];
Jason
i created an excel sheet and concatenated it. But thanks for your input...