add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
15 rows affected
CustomerNumber Company Year WeekNumber LeadDays_1 OrderDate_1 DeliveryDate_1 LeadDays_2 OrderDate_2 DeliveryDate_2 LeadDays_3 OrderDate_3 DeliveryDate_3 LeadDays_4 OrderDate_4 DeliveryDate_4 LeadDays_5 OrderDate_5 DeliveryDate_6
5002 Comp_A 2022 15 1 2022-04-03 2022-04-04 1 2022-04-04 2022-04-05 1 2022-04-05 2022-04-06 1 2022-04-06 2022-04-07 1 2022-04-07 2022-04-08
19401 Comp_B 2022 15 1 2022-04-04 2022-04-05 1 2022-04-05 2022-04-06 1 2022-04-06 2022-04-07 1 2022-04-07 2022-04-08 1 2022-04-08 2022-04-09
310365 Comp_A 2022 15 1 2022-04-05 2022-04-06 1 2022-04-07 2022-04-08 null null null null null null null null null
310428 Comp_A 2022 15 1 2022-04-06 2022-04-07 null null null null null null null null null null null null
Warning: Null value is eliminated by an aggregate or other SET operation.