public inbox for [email protected]  

help / color / mirror / Atom feed

From: Alban Hertroys <[email protected]>
To: Anthony Apollis <[email protected]>
Cc: Adrian Klaver <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: Destination Table - Condition Amount 0
Date: Thu, 8 Aug 2024 20:48:32 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAJyMCYKmmuGDjbWgnBCLxh4y1YpggG7F_5ZxPRz4v1ERysjB0Q@mail.gmail.com>
References: <CAJyMCYJ9GJvJoY9MGvzyf-gO9ZnAwVrZSgrPfn0dGaChdb93HA@mail.gmail.com>
	<[email protected]>
	<CAJyMCYKmmuGDjbWgnBCLxh4y1YpggG7F_5ZxPRz4v1ERysjB0Q@mail.gmail.com>



> On 8 Aug 2024, at 20:07, Anthony Apollis <[email protected]> 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 in your data changed. My bet is on the latter.

For example, in FY25 the value of NCD_EXCL."Order Quantity" is 'NCD Valid FY25’, which doesn’t match your LIKE expression. Even something like a trailing space to the value could be enough.

Alban Hertroys
--
There is always an exception to always.

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Destination Table - Condition Amount 0
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox