topic Re: join problem(excel Data) in QlikView

join problem(excel Data)

Mon, 27 Jul 2015 20:30:31 GMT

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

Re: join problem(excel Data)

robert_mika — Mon, 27 Jul 2015 20:35:51 GMT

Could you add your Excel file?

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

Re: join problem(excel Data)

Mon, 27 Jul 2015 20:47:54 GMT

hi please find sample data !

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

Thanks,

Re: join problem(excel Data)

robert_mika — Mon, 27 Jul 2015 20:54:58 GMT

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

Re: join problem(excel Data)

Mon, 27 Jul 2015 21:00:27 GMT

yes

Worker: Worker Supervisor

with

Hiring Manager

May be problem with Excel

there is no Merge & Center Manager column

Re: join problem(excel Data)

robert_mika — Mon, 27 Jul 2015 21:07:24 GMT

But there is no matching values between those columns.?

Worker: Worker Supervisor

fffff

ggggg

ttttt

and

Hiring Manager

John, Miche

Charf, Eric

Gill, Micha

Re: join problem(excel Data)

Mon, 27 Jul 2015 21:18:10 GMT

Hi please find sample data.

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

am i right?

Re: join problem(excel Data)

robert_mika — Mon, 27 Jul 2015 22:01:53 GMT

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