Create new field in loadscript based on values other field
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?