Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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.
