3 Replies Latest reply: Nov 9, 2016 10:04 PM by qlik777 view777 RSS

    How to split one field into two fields based on output of another field

    Carmen du Plessis

      Hi

       

      I have 1 field called OPTFIELD that contains two values/options,

      1. OEINV which represents Sectors ie. Education
      2. OEPROJ which represents Projects ie. Victoria Primary School

       

      Then I have a field called VALUES that contains the descriptions for the Sectors and Projects.

       

      To visualise this in a table, it currently looks like this:

         

      INV NUMBEROPTFIELDVALUES
      IN00001OEINVEducation
      IN00001OEPROJVic Primary School
      IN00002OEINVHospital
      IN00002OEPROJVic Hospital

       

      I need it to look like this:

      INV NUMBEROEINV (SECTOR)OEPROJ (PROJECT)
      IN00001EducationVic Primary School
      IN00002HospitalVic Hospital

       

      How would I do this in the Qlik Sense script?

       

      Thanks

      Carmen