Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
Is there a way to change the load order?
I wanted to use the above() function but the results weren't what I expected.
Even if I sorted the csv like I wanted, there were still some records where de load order was different.
That could work.
Is there a way to create a list with all seconds in 24h 🙂
Do you mean create all the time stamps of 24 hours?
Off the top of my head you could do something like:
SET vL.Hours = 0;
SET vL.Minutes = 0;
SET vL.Seconds = 0;
TimeTable:
LOAD * INLINE [Time];
for k=0 to 23
SET vL.Minutes = 0;
for j = 0 to 59
SET vL.Seconds = 0;
for i = 0 to 59
concatenate (TimeTable) LOAD MakeTime($(vL.Hours), $(vL.Minutes), $(vL.Seconds)) as Time AutoGenerate 1;
LET vL.Seconds = $(vL.Seconds) + 1;
next
LET vL.Minutes = $(vL.Minutes) + 1;
next
LET vL.Hours = $(vL.Hours) + 1;
next
SET vL.Hours =;
SET vL.Minutes =;
SET vL.Seconds =;
SET i=;
SET j=;
SET k=;
Probable not the most efficient way to do it as it needs to concatenate 86400 load statements of one record, but it's easy and has a low load time
Hope it helps.
Best regards.