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.