Output data

[MROGK]

Can someone help me with the output? I'm looking for list of books that were in '0' stock in the history. The result should also show the books as of  not available as of Feb 15th. Thankyou. Attached the data sheet.

Book	Start Date	End Date	# of days	Reason

[TheOC]

hey @MROGK 

Is this what you need?

Please find attached,

Cheers,
TheOC

[Qiu]

@MROGK 
If I get your logic correctly, this would be a very interesting one. 😁

[MROGK]

@Qiu 

Thankyou very much. I do have a follow-up though. If I have the different reason code over the consecutive days,  Group # is still the same (need a diff.group #). See below -with same group #, the final output shows up with missing dates. I attached the slightly modified input file. Appreciate your help.

Row 1- I want the End Date to be 2/14/2022,

Row 3- Start Date to be 2/12/2022

Similar on Row 9 & Row 10.

[Qiu]

@MROGK 
Allow me some time to check your comment. and get to back you.
Having a busy day ahead me. Let me try take a look at the weekend. 😁

[MROGK]

Dear @Qiu - any opportunity you had to look into my follow-up request? thanks 

[Qiu · Accepted solution]

@MROGK 
I am sorry for keeping you waiting.
I have modified the flow to handling the case that availablity is 0 with different reasons.

I would like to submit this one as a weekly challenge, do you agree? 😁

[MROGK]

Thank you @Qiu . Appreciate you taking time. The solution worked. I'd totally agree that this is worth the wkly challenge. Thanks again.