Looking for some help around the use of the WHERE statement.
I have an excel data source where I need to excluded some data rows from the load process. I found a previous thread that helped when using WHERE once, however, I have several data columns that also have data in which needs to be excluded from the load.
I have used the following script:
Where ColumnA <> 'Zebra';
This successfully removed all rows that had Zebra in ColumnA, however when I try to add another clause using OR referring to a different column neither fields work
Where ColumnA <> 'Zebra' or ColumnB <> 'Lion';
I have tried substituting OR for AND, but this changes the way the clause works (at least in my head) as it is looking for data that equals both clauses.
