1 Reply Latest reply: Jan 31, 2017 1:41 PM by Vegar Lie Arntsen RSS

    How to filter certain data in columns in the Load Editor

    Sara Vasquez



      I am trying to limit some of the data that I am loading. I have a column that has Test such as ELA Test 01, Math Test 01, etc... I want to make sure I only bring the ELA tests so not sure what it should be.


      I am used to using

      WHEN MATCH ([column], 'a','b','c')

      but is there such a thing as

      WHEN contains ([column], ELA)


      Also, will there be a way to do a boolean when it contain ELA or English


      I have tried looking for a place with the the scrip, but I cant find it anywhere.