Insert Missing dates and rows if there is no Inventory

AnanditaShankar

Hi. I am trying to insert missing dates between 31st Decemeber 2021 till 31st July 2023 when there is no inventory noted on that day. For eg: If Plant Y352 has inventory only on 1st jan and 3rd jan then it should insert a row with missing dates and copy the same information for Y352 for 31st Dec 2021 and 2nd Jan with Inventory as 0 . Attaching an excel with expected input and output

Sample logic.xlsx

Workflow

Datasets

Transformation

Preparation

Accepted answers

@AnanditaShankar if you want it specifically between those dates, you can do it like this:

Screenshot 2023-08-03 134429.png

Add all dates.yxmd

All comments

Hi @AnanditaShankar , here is one way to add all the missing dates. Hope it helps!

Screenshot 2023-08-03 101804.png

Add all dates.yxmd

@AnanditaShankar,

Another way to do it.

Attached the zipped workflow and batch macro.

CreateRow_WF.yxzp

philipmannering

This is how I'd do it,

Screenshot 2023-08-03 110557.png

Generate Days.yxmd

AnanditaShankar

The dates should not be generated just based on Min and max dates but for all the dates between 31st Dec-2021 to 31st July 2023

philipmannering

Ah, I think @FinnCharlton 's solution does that.

AnanditaShankar

No it doesn't. i tried it

AnanditaShankar

I checked the count of dates generated across each plant and it's not the same for all

@AnanditaShankar if you want it specifically between those dates, you can do it like this:

Screenshot 2023-08-03 134429.png

Add all dates.yxmd

AnanditaShankar

Thanks @FinnCharlton . This is what I wanted.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703