Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51\))
Subject: Re: Destination Table - Condition Amount 0
From: Alban Hertroys <haramrae@gmail.com>
In-Reply-To: <CAJyMCYKmmuGDjbWgnBCLxh4y1YpggG7F_5ZxPRz4v1ERysjB0Q@mail.gmail.com>
Date: Thu, 8 Aug 2024 20:48:32 +0200
Cc: Adrian Klaver <adrian.klaver@aklaver.com>,
 pgsql-general <pgsql-general@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <59275D17-8C36-4297-AD02-46B515ED3D0F@gmail.com>
References: <CAJyMCYJ9GJvJoY9MGvzyf-gO9ZnAwVrZSgrPfn0dGaChdb93HA@mail.gmail.com>
 <adddb99c-448a-4a6e-a1d1-ab8c50b6c073@aklaver.com>
 <CAJyMCYKmmuGDjbWgnBCLxh4y1YpggG7F_5ZxPRz4v1ERysjB0Q@mail.gmail.com>
To: Anthony Apollis <anthony.apollis@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/59275D17-8C36-4297-AD02-46B515ED3D0F%40gmail.com>
Precedence: bulk


> On 8 Aug 2024, at 20:07, Anthony Apollis <anthony.apollis@gmail.com> =
wrote:
>=20
> 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=E2=80=99s 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=E2=80=99, which doesn=E2=80=99t 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.