On Wednesday, February 14, 2024, Anthony Apollis <
anthony.apollis@gmail.com> wrote:
Conversion Table :
CREATE TABLE IF NOT EXISTS dim."IMETA_Master_Currency_Data_TA_BR"
(
"Currency" character varying(255) COLLATE pg_catalog."default",
"Currency name" character varying(255) COLLATE pg_catalog."default",
"Currency from" character varying(255) COLLATE pg_catalog."default",
"Scenario" character varying(255) COLLATE pg_catalog."default",
"Fiscal year" double precision,
"Fiscal period" character varying(255) COLLATE pg_catalog."default",
"Currency from value" double precision,
"Currency to value" double precision,
"Loaddate" date
)
Your data type choices are unconventional and even arguably wrong for using double for currency.
I am getting no output for using:
FROM
system."IMETA_ZTRB_MP$F_ZTBR_TA_BW2" z
WHERE
z."Fiscal_Year" = 2024
Your table contains no matching rows. The use of left join basically precludes any other explanation.
David J.