Output data

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

Alteryx sample.xlsx

Output

Preparation

Accepted answers

Qiu

@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? 😁

0302-MROGK-r1.yxmd

All comments

TheOC

hey @MROGK

Is this what you need?

Please find attached,

Cheers,
TheOC

MROGK.yxmd

Qiu

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

0302-MROGK.yxmd

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.