How to do multiple conditions in Criteria Column

[msubacha]

How to give multiple conditions in "Criteria" Column in "Choose a table or Query" of ODBC tables.

[LordNeilLord]

Hey @msubacha

Can you give me an example of what you're trying to do?

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[msubacha]

Thanks for asking. Under the "criteria", I would like to provide some supplier code that should be excluded from the query. ie., Not equal to ("ACCSE","ACCSA",HASTY","JUPTY");

Instead of filters used after data retrieval, I want the query to select only the records not equal to (!=)("ACCSE","ACCSA",HASTY","JUPTY");

[LordNeilLord]

Hey @msubacha

Under the criteria you can write:

Not In ('ACCSE','ACCSA','HASTY','JUPTY') like this:

Personally I find it easier to use the SQL editor where you can write it in easier:

I'm presuming this is a SQL table you're connecting to...other databases may have a slightly different syntax for writing "NOT IN"

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[msubacha]

Thanks. I think my mistake was I used double quotes instead single quote. Let me try and get back to you. Really appreciate your effort. I am having little knowledge in SQL. So I always write things or manually select. Thanks again.

[LordNeilLord · Accepted solution]

No worries,

Double Quotes signify a column name, signal quotes signify a value

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[msubacha]

Thanks a lot. It worked well. Thanks again