Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions?
Ask here!
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.
