Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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

 

Labels (6)
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​