Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a scenario unable to do this scenario. The requirement is client has source data looks in attachments here .
If client writing Query on the database like below :-
select
EMPLOYMNT_TYPE_ID,
count(staff_id)
from
FACT_STF_DEMOGRPHCS s2
WHERE
( RS_DATE_ID=0 OR RS_DATE_ID>20151115)
AND
KEY_FIELD = (SELECT MAX(KEY_FIELD)FROM FACT_STF_DEMOGRPHCS WHERE staff_id = s2.staff_id)
GROUP BY EMPLOYMNT_TYPE_ID ;
Client able to get result like below:
Staff ewmployment type count(Staff_id)
contract 72
Perminent 182
Asper qlickview expresion i have written code as below:
DISTINCT [(h)Staff ID])
Result i am getting is
contract 85
Perminent 179
can some one help to fix this issue. my gmail id is mcrao1@gmail.com, my contact number in watsup is +601139329865. Thanks in advance - Chala