change load order

[kristof_j]

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.

[kristof_j]

That could work.

Is there a way to create a list with all seconds in 24h 🙂

[Luis_Cortizo]

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.