If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hello Fellas ,
A newbie here . I want to create two new fields and repeat values in those . This being unkown domein fr me , if this gonna be huge script ?
1. is it Straight table?
2. what based you have give value as alpha?
In a new section in your load below your original you could try the following:
Load*,SubField(IPUAC_temp,'-',1)as NewField1,SubField(IPUAC_temp,'-',2)as NewField2;
Load*,If(Len(Trim(IPUAC)), IPUAC, Peek(IPUAC_temp)) AS IPUAC_temp;
Resident YOURTABLENAMEorder by IDnew asc, IPUAC desc ;Drop Table YOURTABLENAME;
My results from using the above.