If Condition in Where Clause in Load statement

[karan_kn]

Where Condition for Load Script
Create Year should be less than 2021 
If Stage =A then Close Year should be less than 2021 else no restriction for Close Year 

Result: (Exclude highlighted in Yello)

T1:
LOAD * INLINE [
ID, Stage, Create_Yr, Close_Yr
1, A, 2018, 2018
2, A, 2018, 2021
3, C, 2017, 2020
4, C, 2018, 2018
5, A, 2018, 2021
6, D, 2018, 2020
7, D, 2018, 2020
8, E, 2021, 2022
9, E, 2018, 2023
10, H, 2021, 2025
];

[BtBread · Accepted solution]

Hello.
my suggestion:

T1:
LOAD * INLINE [
ID, Stage, Create_Yr, Close_Yr
1, A, 2018, 2018
2, A, 2018, 2021
3, C, 2017, 2020
4, C, 2018, 2018
5, A, 2018, 2021
6, D, 2018, 2020
7, D, 2018, 2020
8, E, 2021, 2022
9, E, 2018, 2023
10, H, 2021, 2025
]

Where (Create_Yr<2021) and not (Stage='A' and Close_Yr>2020)

;