Hello,
I have a simple data table as shown below:
| F11 | F21 | Candidate 1 | Candidate 2 | Candidate 3 | Candidate 4 | Candidate 5 | Candidate 6 | Candidate 7 | Candidate 8 |
|---|
| | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 |
| | Is Employee's status in Bidder's Company currently Permanent? |
| YES | YES | NO | YES | YES | | | |
| | Select Secondary Qualification/Education Level |
| L2 | L1 | L1 | L1 | | | | |
| | 5 | 4 | 6 | 7 | 8 | | | |
| | Have you submitted documents |
| YES | YES | YES | YES | YES | | | |
| | Have you submitted - Candidate’s Education Certificate |
| YES | NO | YES | YES | YES | | | |
I'm trying to build flags based on some specific criteria:
1. Flag1 is based on the field 'CV Submitted by Bidder'. If Total Number of CVs submitted by bidder <=5, Fail,Pass.
2. Flag 2 is based on the field 'Is Employee's status in Bidder's Company currently Permanent?'. IF no. of 'YES' responses to this question <5, Fail, Pass.
3. Flag 3 is based on the field Select Secondary Qualification/Education Level . If <5 blank responses, fail, pass.
4. Flag 4 is based on the field Total Working Experience. If 5 Candidates have less than 5 years of experience, then FAIL; less than 7 years of experience, OKAY,else Pass.
5. Flag 5 is based on the field Have you submitted documents. If < 5 responses are "YES", then Fail, else Pass.
6. Flag 6 is based on the field Have you submitted - Candidate’s Education Certificate. If < 5 responses are "YES", then Fail,else Pass.
I have run out of ideas on how I can transform the table to convenience and build all of these flags in the script itself. Please help me with the transformation and the logics for the flags as above. Any help is much much appreciated! Thanks in advance!
stalwar1
