topic Re: Load from warehouse limited to a specific year in Connectivity & Data Prep

Load from warehouse limited to a specific year

Sebastian_Dec — Mon, 24 Apr 2023 11:36:56 GMT

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" ;

Re: Load from warehouse limited to a specific year

Or — Mon, 24 Apr 2023 12:02:03 GMT

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.

Re: Load from warehouse limited to a specific year

Sebastian_Dec — Tue, 25 Apr 2023 06:41:49 GMT

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" ;

Re: Load from warehouse limited to a specific year

Prem0212 — Tue, 25 Apr 2023 06:59:07 GMT

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