If the Audit status is 'Assign to' and then we want to use Audit Info as 'ROLE:Analyst' in audit table, then it needs to map (To map with the Activ_Role we need to remove suffix ROLE in audit table.) with the 'Activ_Role' Analyst' and show the field as Active_Role_Final.
Please find the sample qvw file and advice me the code to implement.
First we need to click on assign to in audit table,
Next If we click on audit info ROLE:Analyst, then it need to map with Activ_Role 'Analyst'. For mapping the Audit Info field to Activ_Role, we need to remove suffix ROLE: in Audit Info field then we need to map to Activ_Role.
Finally i need to show the Active_Role_Final as one new field with values like Analyst,Architect,Consultant....