Hello there, Alteryx fellows.
I'm facing a complex issue with my current workflow, and I need your help. In the table below this text, you can find an example (with mock names) of the data in which I'm working on. This a full list of the Resources who are involved in Chargeable projects along those ones who have no Chargeable projects in the 3 upcoming weeks. The ones with no chargeable projects need to be in the list and I've made them to appear with all the fields in blank except for their name and rank. However, some resources (take the examples of "the Offender, Bender" and "Fry, Phillip J.") are involved in both "Chargeable" and "Non Chargeable" (blank) projects, and I want them only to show the Chargeable ones.
In summary, I want a full list that shows all the resources who are engaged in a "Chargeable" plus the resources that aren't involved in any. How can I eliminate the "Blank" lines for those resources that also have a "Chargeable Project"?
