Join a table with Stored Procedure in Qlikview

[bvssudhakar]

Hello Experts,

I have one Stored Procedure Query which is

exec sp_Reports_JobActivityTracker @HiringManagerID=0,@RecruiterID=0,@EntereDateTo='10/30/2018',@EntereDateFrom='1/1/2016',@CompanyID=0

Now i have one table which is

load*,

Pick(Match(ishotjob, -1, 0), 'Open', 'Close') as JobStatus;

select J.jobid,J.ishotjob,J.Department,J.countryid,S.Skillname from Jobs j cross apply (SELECT TOP 1 SR.SkillName  

     FROM  dbo.JobSkills JS WITH(NOLOCK) INNER JOIN  dbo.SkillsReference SR WITH(NOLOCK)  

     ON JS.SkillID = SR.SkillID 

     WHERE JS.JobID = J.JobID ORDER BY JS.SKILLID )S

Where J.CountryID = 'IN';

I want to Join (left join) these two by using jobid but how to do i am not able find i used one way but it's not working can you guys please help me out from this

It's very urgent requirement

stalwar1‌marcowedel‌franky_h79‌‌sifatnabil‌Massimo Grossi dushan chathuranga.

mbaeyens

Thank you in advance

[PrashantSangle · Accepted solution]

Store output of both query in qvd then perform join

Regards,

[jonathandienst]

Perhaps rather than joining, let Qlik just associate the two tables on jobid.

But if you want to join them, just load the table from the SP, then use a join qualifier to join the second table:

Table:

SQL Exec sp_Reports_JobActivityTracker @HiringManagerID=0,@RecruiterID=0,@EntereDateTo='10/30/2018',@EntereDateFrom='1/1/2016',@CompanyID=0;

Left|Inner|Outer Join(Table)

Load *,

Pick(Match(ishotjob, -1, 0), 'Open', 'Close') as JobStatus;

SQL select J.jobid,J.ishotjob,J.Department,J.countryid,S.Skillname

From Jobs j cross apply (SELECT TOP 1 SR.SkillName 

    FROM  dbo.JobSkills JS WITH(NOLOCK) INNER JOIN  dbo.SkillsReference SR WITH(NOLOCK) 

    ON JS.SkillID = SR.SkillID

    WHERE JS.JobID = J.JobID ORDER BY JS.SKILLID )S

Where J.CountryID = 'IN';

Choose the type of join from the bold options above.