Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"
;
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.
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"
;
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.
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"
;
in the load script editor if u can use the where condition for the year filed as 2023 then it works.