Extractor Condition from DB

abhaysingh — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a table and Data is coming every minutes, due to large data application is getting slow.

I want to put the condition while extracting the data should be every 10 minutes only rather than every minutes?

data set record would be like this

01.01.01 12:00:00

01.01.01 12:01:00

01.01.01 12:02:00

01.01.01 12:03:00

01.01.01 12:04:00

01.01.01 12:05:00

01.01.01 12:06:00

01.01.01 12:07:00

01.01.01 12:09:00

01.01.01 12:10:00

01.01.01 12:11:00

output require like records would be

01.01.01 12:00:00

01.01.01 12:10:00

and so on.

Pls suggest

Regards

Abhay

Re: Extractor Condition from DB

santiago_respane — Mon, 16 May 2016 14:38:17 GMT

Hi Abhay,

here's an example of how you can achieve this:

TEST:

LOAD * WHERE MOD(RawFieldFormattedAsMinute,10)=0; //Keep only the ones that MOD of division by ten is zero

LOAD *,Minute(RawFieldFormatted) AS RawFieldFormattedAsMinute; //Get minute value from fromatted date

LOAD *,DATE#(RawField,'DD.MM.YY HH:mm:ss') AS RawFieldFormatted; //Date formatting

//Your sample data

LOAD * INLINE [

RawField

01.01.01 12:00:00

01.01.01 12:01:00

01.01.01 12:02:00

01.01.01 12:03:00

01.01.01 12:04:00

01.01.01 12:05:00

01.01.01 12:06:00

01.01.01 12:07:00

01.01.01 12:09:00

01.01.01 12:10:00

01.01.01 12:11:00

];

Please let me know if this help.

Kind regards,

topic Re: Extractor Condition from DB in QlikView

Extractor Condition from DB

Re: Extractor Condition from DB