Re: To Load 25 Months of Data from DB - Qlik Community

Purushothaman · ‎2023-11-17

Hello Experts,

I need to load a table from DB Table "Product". The Product Table got 10 years worth of data.

I need to load only always 25 months of data at any time based on field “Received_date_time” .

How should do it data load editor?

Example of DB Table:

PRODUCT:

Please help!!

Thank you!

whiteymcaces · ‎2023-11-17

The concept for this answer is simple.

Table:

Load

Fields

From DataBase

Where [Date Field] > Today() - [25 Months Ago];

The complexity is based around when you reload data, how often you reload data, and your definition of '25 months ago'.

Purushothaman · ‎2023-11-17

Thank you for your reply. At any given time, The “Received_date_time” to load last 25 months of data from today.

The data load will happen daily basis.

whiteymcaces · ‎2023-11-17

Assuming you reload today (17 Nov 2023), what date will the first row of data be?

To Load 25 Months of Data from DB