topic Re: Simple Join Question in QlikView

Simple Join Question

amien — Mon, 27 May 2013 12:11:35 GMT

I have a table with employe data. I need to join a [Job ID] to this fact table.

This Job ID comes out of different tables. the first table is leading and on employee ID level. The second is on department ID level. the JOINS need to be on different level.

So, if there is no Job ID found in the first table (Job ID > 0) then try to find a Job ID in the second table.

The result must be one additional column added to the emplyee table : Job ID

Thanks in advanced

Re: Simple Join Question

er_mohit — Mon, 27 May 2013 12:36:25 GMT

Using applymap you can do this

but make sure that one primary key is available between both table

hope it helps

Re: Simple Join Question

amien — Mon, 27 May 2013 12:38:12 GMT

Thanks for your reply.

I know APPLYMAP .. but i don't quite understand how to use it with this issue. Can you extend your answer?

EDIT:

I think i got it:

load 2 MAPPING load tables : first column key, second JOB ID

Then in fact table load APPLYMAP('first table',First Key,APPLYMAP('second table',second key','not found')

Re: Simple Join Question

er_mohit — Mon, 27 May 2013 13:23:14 GMT

the table where your Jod id is present on above if your employee data table loaded previously then make

join(employee)

if your both table having none common then in both table make rowno() as Link_Key

so that your job id ll be join

hope it helps

Re: Simple Join Question

amien — Mon, 27 May 2013 20:45:48 GMT

thanks mohir. I fixed it with a double APPLYMAP without using any JOINS