Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sc8Nu-004E8n-Fz
	for pgsql-general@arkaria.postgresql.org; Thu, 08 Aug 2024 19:01:14 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sc8Ns-00GImQ-Ig
	for pgsql-general@arkaria.postgresql.org; Thu, 08 Aug 2024 19:01:12 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1sc8Nr-00GImI-BW
	for pgsql-general@lists.postgresql.org; Thu, 08 Aug 2024 19:01:12 +0000
Received: from fout3-smtp.messagingengine.com ([103.168.172.146])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1sc8Nl-003kvf-Q4
	for pgsql-general@lists.postgresql.org; Thu, 08 Aug 2024 19:01:10 +0000
Received: from compute6.internal (compute6.nyi.internal [10.202.2.47])
	by mailfout.nyi.internal (Postfix) with ESMTP id 16319138E9B5;
	Thu,  8 Aug 2024 15:01:04 -0400 (EDT)
Received: from mailfrontend2 ([10.202.2.163])
  by compute6.internal (MEProxy); Thu, 08 Aug 2024 15:01:04 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h=
	cc:cc:content-transfer-encoding:content-type:content-type:date
	:date:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to; s=fm2; t=1723143664;
	 x=1723230064; bh=tT7s+il3I2nBYUc8WB/B8n2CwyZwwp40qh8dORuZkGU=; b=
	LCkT5ufIlfCE4alui4ub9AHSV1uWPcj1vw9qD9OmLfGtuN2ggvJfBAWG8s+4bBFV
	VMcqgXtxDUm0iqMd1X8pVoMGde+bbw3btSqlvcCjPtjf5dXK9TZEJv5nUyOAft/t
	pxM/HiJ/nkFLZobZ7wikkxhR8mhYeZLEoztxOoaICoz4ENLEjDiJ1ozVFatlmfT4
	qGtAJ20WmVs4d3cl56xA6lLXSL3OcOl6SZYKEWGIOT75OV/c6DHweNAsoLgc0DQc
	hJOH5ZTCWmtNnaHNu9PVn1qy6LdD61RHnEqkOQ/J0R0muwf9TAeditpA4TDAXeG7
	abZYLKF6l9zcjutPWaeA0w==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:cc:content-transfer-encoding
	:content-type:content-type:date:date:feedback-id:feedback-id
	:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy
	:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1723143664; x=
	1723230064; bh=tT7s+il3I2nBYUc8WB/B8n2CwyZwwp40qh8dORuZkGU=; b=o
	YhYsRABh3r+ga/k1ABF+h7IuLA39n3MLQTm3HvCVCz82cLyG7P1DZSRy9s/644kC
	llOaF91JhsrknmrK3xKdvQ7rThwqte670wl5NHsEa26q6DKjnAF2DN2mhYeR7PoY
	nsCFlVl4M9B6rxG3Mh3uqlK857KYHtKEFx4tnDbVoVyboB+eL1dZ3q9tFLyAtpsw
	7elHARuA0a2/pkdWHBRlFCt2JtCmiQm9syGr72Nt4+s61ljUO9C07BIdZueUk29j
	oV7xsud0vS8HDJCIwjivCx6Ky+gSbkJZy6kQrY+55Y1K605Yq3JbW4R7fKldPwN7
	sTcl1vfzJZfii8nQok5DA==
X-ME-Sender: <xms:7xW1ZqtQ_IF8HhSwQzQwuu6zR4pBFi3VqN3iZWt24IRfAvk8nM8Pwg>
    <xme:7xW1ZvcWgvibgioEPqcEvEPq8PvjMVHpOSoPgIOFaQXaFQ_-ymtEkocJZHcJ7O0qQ
    K8kDg0rlcyg_Yk>
X-ME-Received: <xmr:7xW1ZlwJGgUM7qiIe683PDVFvRwDhdeLBpjqxJDddb80iNOfjl6rWKxM7ldDNfmuJ4t-IT2TYpEbIZjfUu14uHBS4R0>
X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrledvgddufedvucetufdoteggodetrfdotf
    fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu
    rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh
    htshculddquddttddmnecujfgurhepkfffgggfuffvvehfhfgjtgfgsehtjeertddtvdej
    necuhfhrohhmpeetughrihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrh
    esrghklhgrvhgvrhdrtghomheqnecuggftrfgrthhtvghrnhephfeviefhveelffeftdeh
    udekveefhfeftdegieefveetfffgfeehtdfftedutedtnecuvehluhhsthgvrhfuihiivg
    eptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghk
    lhgrvhgvrhdrtghomhdpnhgspghrtghpthhtohepvddpmhhouggvpehsmhhtphhouhhtpd
    hrtghpthhtoheprghnthhhohhnhidrrghpohhllhhishesghhmrghilhdrtghomhdprhgt
    phhtthhopehpghhsqhhlqdhgvghnvghrrghlsehlihhsthhsrdhpohhsthhgrhgvshhqlh
    drohhrgh
X-ME-Proxy: <xmx:7xW1ZlMQMj56EqclMbycDUy0CUUOm-QaPPSxAsjJ61A0HjUdxIVJrw>
    <xmx:7xW1Zq9Jw7hh58DEr_aIX29-fmnRWvqBtAOMSuUmc8LCoV2Vq7w1aw>
    <xmx:7xW1ZtU1lE_ESxCXukGhFfXRioXzs832mf_Uo3kifZl5clUbVzYSBw>
    <xmx:7xW1ZjfbcdOXnOr9dSNlbmsMZf_UuTipy9qW-XY48F4pF64-_T77YQ>
    <xmx:8BW1ZsI9BjA4NWTTT7RIygCWgZcOc9CYL4U0KYdmHSdJ9M3VZELGAD9L>
Feedback-ID: i76984098:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu,
 8 Aug 2024 15:01:03 -0400 (EDT)
Message-ID: <e773f743-f93a-4fa0-a4b3-a4de39a07fb0@aklaver.com>
Date: Thu, 8 Aug 2024 12:01:02 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Destination Table - Condition Amount 0
To: Anthony Apollis <anthony.apollis@gmail.com>
Cc: pgsql-general@lists.postgresql.org
References: <CAJyMCYJ9GJvJoY9MGvzyf-gO9ZnAwVrZSgrPfn0dGaChdb93HA@mail.gmail.com>
 <adddb99c-448a-4a6e-a1d1-ab8c50b6c073@aklaver.com>
 <CAJyMCYKmmuGDjbWgnBCLxh4y1YpggG7F_5ZxPRz4v1ERysjB0Q@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAJyMCYKmmuGDjbWgnBCLxh4y1YpggG7F_5ZxPRz4v1ERysjB0Q@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/e773f743-f93a-4fa0-a4b3-a4de39a07fb0%40aklaver.com>
Precedence: bulk

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
adrian.klaver@aklaver.com