Inline

[jennytan]

Hi,

Can somebody please help me on this?

Thank you.

I have a field which is ETA time but the value provided is not in hh:mm so I converted it hh:mm using the following:-

then I wanted to assign a delivery window by using the following inline

The results were correct except for 13:00 which it was not able to assign a delivery window

When I changed the inline to the following:-

it was able to assign for 13:00 but 12:00 was assigned with 2 delivery windows

May I know whether it is because of the conversion of the ETA to hh:mm that is causing the issue as when I exported the values to Excel it looks weird

[Vegar]

It's most likely a rounding error that is causing your issue. 

The numeric representation of ETA 13:00 is larger than your F2 12:59 and smaller than your F1 13:00.

Try adding seconds to your F2 time.

Load * inline [
F1,     F2, DeliveryWindow
12:00:00, 12:59:59, 12pm to 3pm
13:00:00, 13:59:59 , 13pm to 4pm];

[avinashelite]

Instead of image could you upload the same data ? that will save time to generate the data ?

[jennytan]

Hi Vegar,



Thank you for your assistance.



I changed the inline as per suggested and there is no duplication for 12:00 but it is unable to assign for 13:00



[cid:image001.png@01D69CC7.D1423390]



[cid:image002.png@01D69CC7.D1423390]

[jennytan]

This is the definition for the inline and the results of the data.

[QFabian · Accepted solution]

hi, try converting the hours to numbers first, and then make the interval over the numbers and not over hours.

see the atached image.