Mapping data

[#1]

Hi Experts,

I have attached a sample qvw which has employee details from two different tables.

The problem here is for one Employee ID, there are two records.

I want to make it as one with all the required data.

i have attached the excel sheet which shows the required output.

Please help me to do this.

[#2]

Hi,

i didnt add duplicates.

Source was given like that. i cant remove duplicates since i need both.

The required fields are there in both the tables

[#3]

I would suggest creating a QVD for Emp data and one for a list of Emp that have Reports to.

this would allow you to do the one row per emp join to one manager data line (both from the same qvd)

[tresesco]

TABLE1:

LOAD [First Name],

    [Last Name],

    [Employee ID],

    [Email Address] ,

    [Mobile No.],

    Cisco,

    [IP Phone]

FROM

Test_EM1.xls

(biff, embedded labels, table is Sheet1$);

right join

TABLE2:

LOAD //[First Name],

    //[Last Name],

    [Employee ID],

    //[Email Address],

    Department,

    Location,

    //[Mobile No.],

    // Cisco,

    //[IP Phone],

    [Job Title],

    [Report to (Emp ID)]

FROM

Test_EM.xls

(biff, embedded labels, table is Sheet1$);

[sunny_talwar]

May be this:

TABLE2:

LOAD [First Name],

    [Last Name],

    [Employee ID],

    [Email Address],

    Department,

    Location,

    [Mobile No.],

    Cisco,

    [IP Phone],

    [Job Title],

    [Report to (Emp ID)]

FROM

Test_EM.xls

(biff, embedded labels, table is Sheet1$);

Concatenate (TABLE2)

LOAD [First Name],

    [Last Name],

    [Employee ID],

    [Email Address] ,

    [Mobile No.],

    Cisco,

    [IP Phone]

FROM

Test_EM1.xls

(biff, embedded labels, table is Sheet1$)

Where not Exists([Employee ID]);