I want to filter out multiple rows using their IDs. I want to filter something along the lines [ID] !=('A1','A2',A3','B4',X5') without using the noob approach of having ten thousand AND statements.
Any quick ideas?
Thank you ?
Hi @hellyars,
You use the Value IN operator
!([ID] IN ('A1','A2',A3','B4',X5')) or [ID] NOT IN ('A1','A2',A3','B4',X5')
will work
However, if it is a really long list of IDs, I would probably just bring that list in as an input and then use a join and select whatever did NOT join (as those IDs are not the ones you want).
Works perfectly for small sets. Thank you.
