Re: Destination Table - Condition Amount 0

2024-08-08 Thread Adrian Klaver
On 8/8/24 11:07, Anthony Apollis wrote: The same code bring in values for FY24, 23 etc. Dont understand why FY25's values are 0. Because something changed. You will need to go through the process step by step and verify that the code is current with what is in the FY25 data. -- Adrian Klaver

Re: Destination Table - Condition Amount 0

2024-08-08 Thread Alban Hertroys
> On 8 Aug 2024, at 20:07, Anthony Apollis wrote: > > The same code bring in values for FY24, 23 etc. Dont understand why FY25's > values are 0. If you use the same code for FY24, then either there’s some filter being applied somewhere that excludes FY25 (and probably beyond), or something

Re: Destination Table - Condition Amount 0

2024-08-08 Thread Anthony Apollis
The same code bring in values for FY24, 23 etc. Dont understand why FY25's values are 0. On Thu, 8 Aug 2024 at 18:56, Adrian Klaver wrote: > On 8/8/24 09:35, Anthony Apollis wrote: > > I need your assistance with an ETL process that runs every six months. > > Currently, we are in Calendar Year/F

Re: Destination Table - Condition Amount 0

2024-08-08 Thread Adrian Klaver
On 8/8/24 09:35, Anthony Apollis wrote: I need your assistance with an ETL process that runs every six months. Currently, we are in Calendar Year/FY 2025, which started in July 2024. The issue is with the "Condition Amount" for FY 2025. Data comes through correctly until the "Insert Data Into