Help with excluding rows of data based on criteria in multiple rows

Question

Hello,

I feel like this should be simple but I've tried several different ways to do this and I'm at a loss...

I am attaching a Dataset and a Workflow (although I added my Dataset in the WF in a Text Input).  This workflow is comparing data between 2 years and has example data for 4 "Sub Acct ID" numbers.  The output is basically what I want except that I want it to filter out data for Sub Acct ID's when the DE07 - Description row within the "System Data Fields" column is not empty in the "2024" column and is empty in the "2025" column.

To hopefully make it more clear, I've also provided a file reflecting the expected end result.

FYI - My actual data and workflow is much larger than this.  Thank you in advance for any assistance you can lend! :)

Test Data WF.yxmd

TEST INPUT.xlsx

Test Data -Browser Output.xlsx

cgoad61 · Accepted Answer

Thanks Qiu... while your suggestion did start me thinking in the right direction, there ended up being a bit more to the actual solution.  For anyone interested in what I ended up doing:

1. Used the Summary Tool to group by Sub Acct ID & Concatenate the Sub Acct ID Year

2. Filtered on the Concat field I just created to Contain 2025

3. Join back with the full report

If anyone has a simpler way, please post...

cgoad61 · Accepted Answer

Thanks Qiu...  For the purposes of this file it should always included 2025 but it's only necessary to pull in 2024 if a 2025 line also exists so by doing the Concat it could include ID's with only 2024, only 2025 or both 2024 & 2025.  By filtering on 2025 it pulls in the last 2 scenarios but eliminates the items that are only 2024 and solves my problem.