Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

lukenathan
New Contributor

DLE create new field based on contents of other fields

I have a table with many records and two fields named Group and ShortDesciption. 

GroupShortDesciption
Level1MIT7 GASU5 CSU2TW NYU1 WCU69U
Level3UCLA3 UCI74 WSU9
Level2UPENN10 UNR11 UMASS6 ASU5 VTC5

Via the Data Load Editor I want to search every record in field Group for "Level1" and field ShortDesciption for "MIT7" and "NYU1" then when found I want to insert the string "Positioned" into a new field named District in the same record so the table above looks like this...

GroupShortDesciptionDistrict
Level1MIT7 ASU5 CSU2 NYU1 WCU6Positioned
Level3UCLA3 UCI4 WSU9
Level2UPENN10 UNR11 UMASS6 ASU5 VTC5

Below is the Data Load Script that I have so far, can you help me modify it to accomplish what I described above?

LOAD

    "Group",

    ShortDesciption

FROM [lib://Book1.xlsx]

(ooxml, embedded labels, table is Sheet3);

Community Browser