SO aol , sep,active_status and terminated are attributes
WD LCS NEW REQ.xlsx (9.5 KB)
| TEST CASE | TERMINATED | TERMINATION_DATE | ACTIVE_STATUS | HIREDATE | AOL | SEP | Expected LCS |
|---|---|---|---|---|---|---|---|
| 1 | 1 | 3/1/2025 | 0 | 1/1/2022 | Terminated - Disabled (Termination Date < 35 days from today) | ||
| 2 | 1 | 2/1/2025 | 0 | 1/1/2022 | Terminated - Delete (Termination Date > 35 days from today) | ||
| 3 | 0 | 1 | 4/1/2023 | Y | Y | LOA Disabled (AOL + SEP = Y) | |
| 4 | 0 | 0 | 5/10/2025 | PreHire Disable (Start Date < 30 days from today) | |||
| 5 | 0 | 1 | 4/1/2024 | Active (Start Date ≤ today) | |||
| 6 | 0 | 1 | 5/10/2025 | Y | Keep current state |
Can you provide a transform which you developed? It helps to resolve if you get any error or not giving the expected result.