How do I parse a table of Dates (start / finish), Level(1,0), Type of Wave(Primary, Secondary, Tertiary values). I am trying to determine gap-time between each start date and all following records till EOF.
My CSV file has 15000-20000 records. The start dates are ascending and the level is 1 and then 0 and then 1 ... etc
I am trying to take each record and then process down the subsequent records till I reach the end of the table. Then I would select the next record and go down through the table and repeating this till all records have been processed.
How can I do this? I am very new to Ninox and SQL so I am having trouble. Appreciate help.