基于排除逻辑的数据提取需求（含条件与示例）
2026-8-11
数据提取规则与结果
提取条件
- 提取
Open_amt不等于0的记录中，对应发票（Inv #）的**最新活动日期（Max(Last Activity Dt)）**的那条记录 - 若某发票的最新活动日期对应的记录满足
Open_amt = '0'且State = 'closed'，则该发票的所有记录均排除
原始数据
| Inv # | Account # | Activity | State | Open_Amt | Last Activity Dt | Seq | St_date |
|---|---|---|---|---|---|---|---|
| 123 | Customer1 | Act-1 | Issued | 12.50 | 2022-02-18 | 455 | 2022-01-04 |
| 123 | Customer1 | Act-2 | Closed | 0.00 | 2022-03-05 | 567 | 2022-01-04 |
| 345 | Customer2 | Act-1 | Issued | 15.00 | 2022-02-18 | 467 | 2022-01-12 |
| 345 | Customer2 | Act-2 | Issued | 09.35 | 2022-02-25 | 488 | 2022-01-12 |
| 678 | Customer3 | Act-1 | Issued | 30.50 | 2022-03-20 | 589 | 2022-01-23 |
| 678 | Customer3 | Act-2 | Closed | 00.00 | 2022-03-30 | 623 | 2022-01-23 |
| 678 | Customer3 | Act-3 | Issued | 30.50 | 2022-04-02 | 788 | 2022-01-23 |
| 678 | Customer3 | Act-4 | Issued | 05.50 | 2022-04-10 | 988 | 2022-01-23 |
符合条件的输出结果
| Inv # | Account # | Activity | State | Open_Amt | Last Activity Dt | Seq | St_date |
|---|---|---|---|---|---|---|---|
| 345 | Customer2 | Act-2 | Issued | 09.35 | 2022-02-25 | 488 | 2022-01-12 |
| 678 | Customer3 | Act-4 | Issued | 05.50 | 2022-04-10 | 988 | 2022-01-23 |
内容的提问来源于stack exchange，提问作者user14070248
相关产品推荐
相关产品推荐
