Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
I have the data as BELOW :
EmpName | CoreTraining | Individual training status | trn_code |
---|---|---|---|
EMP1 | CORE | COMPLIANT | T1 |
EMP1 | DELINQUENT | T2 | |
EMP1 | CORE | INPROGRESS | T3 |
EMP2 | CORE | COMPLIANT | T4 |
EMP2 | CORE | DELINQUENT | T5 |
EMP2 | DELINQUENT | T6 | |
EMP3 | - | ASSIGNMENT IN PROGRESS | - |
EMP4 | - | ASSIGNMENT IN PROGRESS | - |
In the output i have to show the data only of those employees who are assigned Core Trainings and for whom no trainings are assigned at all.
Here the output should be which are highlighted above in red color.
Can any one please help me.
Thanks,
Anjee
Hello!
You can find an attachment with a solution.
Hope it can be usefull,
KR
Elena
Hi, Virann,
I think you have to work in sql script using null function or length function to identify it.
Some like this:
Length(CoreTraining) = 0, -1 as CoreTraining
Then you use set analysis to get only CoreTraining <> -1
I hope this will help you
Hello!
You can find an attachment with a solution.
Hope it can be usefull,
KR
Elena
Please post the what is expected output from the above data ?
Thanks for the Reply and it solved my issue .
i resolved in this way :
if(len([CoreTraining])=0 and len(TRAINING_CODE)>0,0,1) and i have filtered the data based on flag=1.
this resolved my issue.
Thanks,
Anjee