Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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_h79sifatnabilMassimo Grossi dushan chathuranga.
Thank you in advance
Store output of both query in qvd then perform join
Regards,
Store output of both query in qvd then perform join
Regards,
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.