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.
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.