topic Re: how to filter data by date in a load script? in Connectivity & Data Prep

how to filter data by date in a load script?

Bruno_Basulto — Tue, 23 Jan 2024 18:14:56 GMT

Hi all,

I need to filter when performing a data load from an Oracle connection using a date and time field that has the following format:

"FEC_SOL" : '2023-01-01 00:00:00.000000'

to bring only information from 2023 onwards.

Thank you!

Re: how to filter data by date in a load script?

MatheusC — Tue, 23 Jan 2024 19:20:54 GMT

Hi, @Bruno_Basulto

From the example, it appears to be a datetime field,

Could you do this in Load instead of Select?

see below

load
...
Where year(Date(Floor(datetime)))>=year(today())-1;

[Table];
Select
...
from;

Regarts,
Matheus

Re: how to filter data by date in a load script?

MatheusC — Thu, 25 Jan 2024 13:41:35 GMT

Did you get the solution?

Close the topic with the solution met and leave a like if you found it useful.

Thank you!

Re: how to filter data by date in a load script?

anat — Thu, 25 Jan 2024 15:07:26 GMT

select * from table where EXTRACT(YEAR FROM datefield) >=year(today())-1

Re: how to filter data by date in a load script?

Bruno_Basulto — Thu, 25 Jan 2024 15:25:19 GMT

Yes! its work!
Thanks.

Re: how to filter data by date in a load script?

WaltShpuntoff — Thu, 25 Jan 2024 15:54:22 GMT

When you are using the Today function in a load script, you should always use Today(1), since Today() or Today(0) is the date of the last successful reload. If you are doing daily updates this makes a big difference.

For details:

Qlik Help for Today() function