topic Join a table with Stored Procedure in Qlikview in QlikView

Join a table with Stored Procedure in Qlikview

bvssudhakar — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Join a table with Stored Procedure in Qlikview

PrashantSangle — Tue, 07 Aug 2018 12:19:00 GMT

Store output of both query in qvd then perform join

Regards,

Re: Join a table with Stored Procedure in Qlikview

jonathandienst — Tue, 07 Aug 2018 12:54:58 GMT

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.