EMP_FNAME EMP_NO Primary_skills subskills_1 subskills_2 Aakash Bhagwan 471855 Informatica DW SSIS Aayta 262151 .net Data Network .Net Framework Abdul Bari Mohammed Talha 457449 Java Java Enterprise - Front End Java Enterprise - Back End Abhijeet Uddhav 359410 DW Qlikview - Abhijit Prabhakar 463855 Python Mainframe Testing Mobile Application Testing Abhinay 444434 Java Java Enterprise - Front End EJP Abhishek 350917 Informatica DW SSIS Abhishek 452867 Java Java Enterprise - Front End Java Enterprise - Back End Abhishek 464076 .net Data Network .Net Framework Abhishek Vijay 458739 DW Qlikview Qliksense Abily 315650 Python Mainframe Testing Mobile Application Testing Abinash 492186 Java - - Abirami 364005 Informatica DW SSIS Abisha 440587 .net Data Network .Net Framework
This is the sample data.For now I want to display the below.
EMP_NO Name Fitment 471855 Aakash Bhagwan 100 262151 Aayta 100 463855 Abhijit Prabhakar 100 34066 Rajkumar Soundararajan 100 359410 Abhijeet Uddhav 75 492186 Abinash 50
I done this by using simple If else statement.
i.e, If (primary_skills = java,50 )
if(subsill1 = 'java front end',25)
if(subsill1 = 'java back end',25)
and I have to calculate the total fitment percentage.This is working fine but If the primary skills and secondary skills are included more I have to edit the script according to the requirement.Instead of editing that I want it to be automatically calculated.Instead of writing it in simple if else is there any other option to do this.