How to filter certain data in columns in the Load Editor

[#1]

Hello,

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.

Thanks,

Sara

[Vegar · Accepted solution]

LOAD

  Wildmatch([column], '*ELA*','*English*')>0 as _ElaEnglishBoolean

FROM/RESIDENT

  YourTable

WHERE

  Wildmatch([column], '*ELA*')