DLE create new field based on contents of other fields

Ask a Question

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

Group	ShortDesciption
Level1	MIT7 GASU5 CSU2TW NYU1 WCU69U
Level3	UCLA3 UCI74 WSU9
Level2	UPENN10 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...

Group	ShortDesciption	District
Level1	MIT7 ASU5 CSU2 NYU1 WCU6	Positioned
Level3	UCLA3 UCI4 WSU9
Level2	UPENN10 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);

0 Replies