Lookup TB Date to TR date and Filter out all lines where Date is higher than Date in TB
TB | TR | |||
Date | Balance | Date | Balance | |
5/24/2023 | 212 | 5/25/2023 | 545 | |
5/24/2023 | 12 | 5/25/2023 | 3535 | |
5/24/2023 | 331 | 5/25/2023 | 3535 | |
5/24/2023 | 212 | 5/25/2023 | 545 | |
5/24/2023 | 212 | 5/23/2023 | 545 | |
5/24/2023 | 212 | 5/23/2023 | 545 | |
Result | ||||
Date | Balance | |||
5/25/2023 | 545 | |||
5/25/2023 | 3535 | |||
5/25/2023 | 3535 | |||
5/25/2023 | 545 |
In your result there is something strange. Why the repetition of this value that is in the print?
@npariso apologies, if it wasn't clear from my side. trying to give more in detail. Thanks, in advance!
Lookup TB Date to TR date and in result it should give all lines from TR-Input file-2 where Date is higher than Date in TB- input file 1.
if you see in the result i want, it did not pick the 5/23/2023 as per the condition.
Input file 1 | |
TB | |
Date | Balance |
5/24/2023 | 212 |
5/24/2023 | 12 |
5/24/2023 | 331 |
5/24/2023 | 212 |
5/24/2023 | 212 |
5/24/2023 | 212 |
Input file 2 | |
TR | |
Date | Balance |
5/25/2023 | 545 |
5/25/2023 | 3535 |
5/25/2023 | 3535 |
5/25/2023 | 545 |
5/23/2023 | 545 |
5/23/2023 | 545 |
Result-TR | |
Date | Balance |
5/25/2023 | 545 |
5/25/2023 | 3535 |
5/25/2023 | 3535 |
5/25/2023 | 545 |