Cast your vote for the official 2025 Inspire Pin! Designs were submitted by fellow Community members and reflect the creativity and passion of Alteryx users across the globe. Vote now!
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
I'm trying to create a filter that would keep all rows except when:
Column B [Portfolio] = Information Technology and column D [Configuration Item] is empty.
Column B [Portfolio] = Mercury and Column D [Configuration Item] is empty.
If Information Technology or Mercury have configuration items then they should not be removed.
Appreciate any help!
Solved! Go to Solution.
HI @BrettFL
Is this what you are looking for?
[Portfolio] = 'US Information Technology' and !IsNull([Configuration item]) or
[Portfolio] = 'Mercury' and !IsNull([Configuration item])
Pedro.
