Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Elena_Charcan
Contributor
Contributor

loop based on database information

Good Morning.

 

I need help with a topic ...

 

I need to loop based on information coming from a database field.

 

I have a file with information and I have to insert it in certain tables, before I have in this file a date field with time, which, in order to insert it, cannot exist in the database, and for this I have to increment it by one second to the time and look for it again, to check that the new date time exists ... so until it does not find any record, then it would take that new date time (if it is increased, if I do not keep the one from the file) to insert it in the table.

 

How can I do that?

 

A greeting and thanks in advance

 

1 Reply
Anonymous
Not applicable

Hi

What is the end time? You mentioned the time will be increased by one second for the next loop.

 

Regards

Shong​