This content has been marked as final. Show 4 replies
I'm trying to develop an If statement that matches several conditions. The reason I am trying to do this is to remove some data that isn't necessary.
We often have people testing inside our database. They'll use a User ID like "ed_t" or "D_ET". So I when I import my data, I don't want to include those in the dataset at all.
My If statement doesn't seem to work, though. It only matches the first condition. Any thoughts?
If(left(lower([User ID]), 3) <> 'ed_t' or 'D_ET', 1) as [Exclude User ID]