Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have EmployeeID in my facts table and the employee dimensions table. Employee name is in the dimensions table. I want to be able to show both the employee names as well as the salespeople (just those associated to orders/opportunities in the facts table) . This would be very simple if I had the actual employee names in the facts table.
How do I get the employee names in the facts table while preserving a field for all employees?
Employee:
Mapping Load EmployeeID, EmployeeName From EmployeeTable;
FactTable:
Load
Field1,
Field2,
Applymap('Employee',EmployeeID,'Unknown') as EmployeeName,
Field3,.....
From FactTableName;
===================================
Or
FactTable:
Load * From FactTableName;
Left Join
Load * From EmployeeTableName;
David,
Please can you explain me your question with example ? So that I can look into .
Facts Table:
Opportunities:
LOAD "Oppo_PrimaryCompanyId" as CompanyID,
"Oppo_AssignedUserId" as EmployeeID,
"Oppo_Description",
"Oppo_Type",
"Oppo_Product" as Product,
...
Dimension table:
Employees:
LOAD "User_UserId" as "EmployeeID",
// "User_LastName",
// "User_FirstName",
"User_FirstName" & ' ' & "User_LastName" as "Employee Name";
...
I need a field that shows only users associated with at least 1 Opportunity (AKA Salespeople).
Thoughts?
Opportunities:
LOAD "Oppo_PrimaryCompanyId" as CompanyID,
"Oppo_AssignedUserId" as EmployeeID,
"Oppo_Description",
"Oppo_Type",
"Oppo_Product" as Product,
Left Join
Employees:
LOAD "User_UserId" as "EmployeeID",
"User_FirstName" & ' ' & "User_LastName" as "Employee Name";
Thanks for the reply, Manish.
I need a separate field that contains ONLY salespeople, as well as a field that contains all employees. A left join does not offer that.
Can you elaborate little more please?