Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create log per second if you have start and end time

Hi,

If i have the following information:

Date

StartTime

Duration (in minutes)

is it possible to create a script where i log each active minute?

In other words, if one line of data contains duration 10 minutes, I would like to build a script that creates 10 lines of data, one line for each minute.

Best Regards

//Hajman

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Hi Hajman,

you could add a while criterion to your load, maybe like:

LOAD

Date,

StartTime,

Duration

from TABLE while iterno() <= Duration;

Regards,

Stefan

View solution in original post

2 Replies
swuehl
MVP
MVP

Hi Hajman,

you could add a while criterion to your load, maybe like:

LOAD

Date,

StartTime,

Duration

from TABLE while iterno() <= Duration;

Regards,

Stefan

Not applicable
Author

Thanks a lot Stefan, now it works as planned!

/Hajman