5 Replies Latest reply: Apr 26, 2017 3:28 PM by Vineeth Pujari RSS

    Create new field in loadscript based on values other field

    Jonah Van Quekelberghe

      Hello,

       

      I have a Table_Source with information per row that I want to show per type in Qlik (see Table_Visual):

       

      What I did now was in the loadscipt to create a separate table per information type with the where clause (so one table for EML, one for GSM and one for TEL). Then in QLik I could create a table with the newly created fields.

      If I created the fields in the same Table_Source, the the result was not what I wanted Table_WrongVisual.

       

      Is there any other way that I can do this in Qlik itself without modifiying the script (DataPivot?) ? Is there a more efficient way in the load script than creating a table field?

       

      Table_Source

      PersonAdres_TypeAdres
      1EML1@gmail.com
      1GSM123456
      1TEL456789
      2EML2@gmail.com
      2GSM987654
      2TEL654321

       

      Table_Visual

      PersonAdres_EMLAdres_GSMAdres_TEL
      11@gmail.com123456456789
      22@gmail.com987654654321

       

      Table_WrongVisual   

      PersonAdres_EMLAdres_GSMAdres_TEL
      11@gmail.com--
      1-123456-
      1--456789
      22@gmail.com--
      2-987654-
      2--

      654321

       

      Thank you!