Simple Join Question

[amien]

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

[er_mohit · Accepted solution]

Using applymap you can do this

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

hope it helps

[amien]

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')

[er_mohit]

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

[amien]

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