Load from warehouse limited to a specific year

[Sebastian_Dec]

Hi, how I can load only one year from warehouse using only one load?

I need load only 2023, not 2000/2021/2022.

Data is in format DD-MM-YYYY

My code:

LIB CONNECT TO 'HD';

sales_tmp:
LOAD
hid_sklep,
date(hid_data) as data,
Year(hid_data) as year,
Month(hid_data) as month,
kod_ean,
hid_segment;

SELECT
"hid_sklep",
"hid_data",
"kod_ean",
"hid_segment"
FROM "public"."sales_72"
;

[Or · Accepted solution]

Where Year(hid_data) = 2023 presumably (unless your database doesn't use Year(), in which case you may need a different function). This isn't really a Qlik question, though, since you're looking for a condition in your SQL statement.

[Sebastian_Dec · Accepted solution]

Hi, thx for help, its works.
My fixed code:

LIB CONNECT TO 'HD';

sales_tmp:
LOAD
hid_sklep,
date(hid_data) as data,
Year(hid_data) as year,
Month(hid_data) as month,
kod_ean,
hid_segment
Where Year(hid_data) = 2023;

SELECT
"hid_sklep",
"hid_data",
"kod_ean",
"hid_segment"
FROM "public"."sales_72"
;

[Prem0212]

in the load script editor if u can use the where condition for the year filed as 2023 then it works.