Created a left join to get Svc Mgr Names but it's not linked to other tables.

[xarapre7]

Hi!  I'm trying to get the names of the Svc Mgrs from Employee table by getting the Svc Mgr ID from the Customer table and left joined it to the Employee table and I was able to get the Svc Mgrs names.  So that when I click on a Svc Mgr ID, it's giving me the corresponding Svc Mgr's name.  However, the other fields from other tables (calendar and transaction tables) are greyed out.  What should I do so that when I click on the Svc Mgr's name, it's also linked to the other tables?  Thank you for your help in advance

EMPLOYEE:
LOAD
       IF (NOT ISNULL(EmployeeID), EmployeeID,0) AS EmployeeID
      ,[LoginID]
      ,[FirstName]
      ,[LastName]    
FROM  $(vQVDPath)\Employee.qvd
(qvd);

//get the Svc Mgr ID from Customer table and join with EmployeeID from Employee table to get the Svc Mgr Names
left join (EMPLOYEE)
LOAD distinct 
      [Svc Mgr ID] as EmployeeID,
       1 as SMID_Filter     
FROM $(vQVDPath)\Customer.qvd
(qvd);

CUSTOMER:
LOAD
     Customer_ID,
     Name,
     City,
     [Zip Code]

FROM
$(vQVDPath)\Customer.qvd
(qvd);

[xarapre7]

Did you add anything to the file?  I don't see anything added or modified.

[prma7799]

Have you check

I think it is reload successfully ..

I have remove , (comma)  from Country

CUSTOMER:

LOAD

     Customer_ID,

     Name & ' (' & replace(ltrim(replace(ltrim(Customer_ID),'0',' ')),' ','0') & ')' AS 'Customer',

     Name,

     City,

     [Zip Code],

     IF(IsNull(State)=0, State,'<NA>') AS CustomerState,

     IF (NOT isnull(Country) AND trim(Country)<>'',Country, '<NA>') AS 'Country' 

FROM

$(vQVDPath2)\qvCustomer.qvd

(qvd);

[xarapre7]

It's successfully reloading but, the SVC Managers are still not connected to the other tables.  If I choose any of the SVC Managers, it's not linked to any of the dates or transaction.  That is the issue that I'm having. 

[prma7799]

Can you please provide qvd's for all tables

[Kushal_Chawda]

see the attached