join problem(excel Data)

[#1]

hi all,

i have 2 tables,

1.head count

2.Hierarchey

common field is Hiring manager

if join with Hiring manager, most of the workers has  blank manager name

any suggestion on join condition

please find the sample application

[robert_mika]

Could you add your Excel file?

Most of us works on PE edition...(at home at least)

[#3]

hi please find sample data !

take my application as binary it wil open i guess in PE

Thanks,

[robert_mika]

Which field is the Key?

I do not see Hiring Manager on Head Count

Looking at your data there is no matching fields between those two tables?

Do you match

Worker: Worker Supervisor

with

Hiring Manager

[#5]

yes

Worker: Worker Supervisor

with

Hiring Manager

May be problem with Excel

there is no Merge & Center Manager column

[robert_mika]

But there is no matching values between those columns.?

Worker: Worker Supervisor

fffff

ggggg

ttttt and

Hiring Manager

John, Miche

Charf, Eric

Gill, Micha

[#7]

Hi please find sample data.

Org Hierarchy i need to fill blanks with Above Manager Name while loading

am i right?

[robert_mika]

org:

LOAD [Business Unit],

     [ITSLT Manager],

     [Sub-Orgnizantion],

     [Hiring Manager]

FROM

(ooxml, embedded labels, table is Sheet1, filters(

Replace(1, top, StrCnd(null)),

Replace(2, top, StrCnd(null))

))

Where len(trim([Sub-Orgnizantion]))>0;;

right join(org)

LOAD [Job Posting Title],

     [Worker: Worker Supervisor] as [Hiring Manager],

     Worker,

     [Worker ID],

     Status,

     [Start Date],

     [End Date]

FROM

(ooxml, embedded labels, table is Sheet1);

You have d got the same ID twice in the org tables