Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
bvssudhakar
Creator III
Creator III

Join a table with Stored Procedure in Qlikview

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

stalwar1marcowedelfranky_h79‌‌sifatnabilMassimo Grossi dushan chathuranga.

mbaeyens

Thank you in advance

1 Solution

Accepted Solutions
PrashantSangle

Store output of both query in qvd then perform join

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

2 Replies
PrashantSangle

Store output of both query in qvd then perform join

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein