topic How to add rows into existing fields? in QlikView

How to add rows into existing fields?

Fri, 19 Aug 2011 16:34:21 GMT

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?

How to add rows into existing fields?

Jason_Michaelides — Fri, 19 Aug 2011 17:24:40 GMT

Under your load script above:

Concatenate (Employee)

Load * Inline [

SalesPersonID,SalesPerson_FirstName,SalesPerson_LastName,Title

291,John,Adams,Sales representative

];

Jason

How to add rows into existing fields?

Fri, 19 Aug 2011 17:26:04 GMT

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