?

[xyz1]

.

[vinieme12]

please use the script i posted As-IS, we are auto concatenating the data from Emp vs Role and Emp vs TEAM

Changing the CrossTable field names will not work , and keep the employee information table separate like I have.

Not sure why you are using left joins or mapping tables for

LOAD [Employee Name],

    Location,

    Site,

    Dept,

    [I/E]

FROM [lib://ResourcePlanning/Resource Planning v1.2.xlsx]

(ooxml, embedded labels, table is [Emp vs Role]);

Temp:

CrossTable (ROLE,Value,2)

LOAD [Employee Name],

  'Individual' as FACT_TYPE,

  [Business Relationship (BRM)],

  [Architect / PM],

  [Analyst],

  [Admin],

  [Support & SME],

  [Project Integrator],

  [Specialist],

  [Technician],

  [Manager / Team Leader],

  [Enable]

FROM [lib://ResourcePlanning/Resource Planning v1.2.xlsx]

(ooxml, embedded labels, table is [Emp vs Role]);

CrossTable(ROLE,Value,2)

LOAD [Employee Name],

     'Team' as FACT_TYPE,

     [Alignment & Direction],

     Performance,

     [Sales, Marketing, and Logistics],

     [Industrial, Quality, and Research],

     [Finance, Purchasing, HR, & IT],

     [Web Application Systems],

     [Content Collaboration],

     [Business Intelligence],

     [B2B / EDI],

     [Data Mart Management],

     Testing,

       [Innovation Center],

     [Engineering and Architecture],

     [Infrastructure and Operations],

     OCM,

     [Security and Risk],

     [Client Services],

     [Access Rights],

     Symphony

FROM [lib://ResourcePlanning/Resource Planning v1.2.xlsx]

(ooxml, embedded labels, table is [Emp vs Team]);