Preceding Load Nested if statement issue

[gangelep]

I want Status of each Shipment ID so i have used nested IF statement in preceding load.

I am using Straight table but getting two rows against some ShipmentID.

I don't want to use "Suppress when value is null" due to some specific business condition.

Could you please help me out here why i am getting blank status row here

LOAD ShipmentID,
If(Loading_Time < Start,'Early',
If(Loading_Time>Stop,'Late',
If(Loading_Time>Start and Loading_Time < Stop,'On Time'))) As Status;
Load *,
Time([PL time]-Buffer_Early,'hh:mm') as Start,
Time([PL time]+Buffer_Late,'hh:mm') as Stop;
Load *
Resident Shipment;

[HirisH_V7]

Sample Data and required output .. will give clear idea.

[Brett_Bleess · Accepted solution]

My best hunch would be you have a result that is not meeting your condition in the If statements, i.e. things are equal maybe, and therefore we do not know what status to apply.  Only way of which I can think to prove that is to cover that in the If statement by adding a final result of some other value if no other conditions are met.  So what I am saying is a final 'else' along the lines of something that will flag we have a condition that is not being met...

Regards,
Brett