Alteryx Multirow-formula not sufficient for date problem

[Mahmoud_Turki]

Hello,

Can someone please help me solve that cross-rows problem? 

• I want to calculate at the current row the number of previous rows that had a production start date in "the last week = 7 last days" like in the screenshot attached
• The rows are sorted in an ascending order according the production date.

I failed to figure that out with the existing formulas. I would be very thankful 

Best regards 

Mahmoud 

[atcodedog05]

Hi @Mahmoud_Turki 

Please provide the above sample excel file.

[atcodedog05 · Accepted solution]

Hi @Mahmoud_Turki 

Here is how you can do it.

Workflow:

Hope this helps : )

[Mahmoud_Turki · Accepted solution]

Hi, 

thank you so much for sharing. This smart solution, based on the "append fields" tool, cannot work for my use case.

• The attached file was just an example. I am working with big data about around 6000 orders with more than 940 unique "date" values.    
• Therefore I got the error "Error: Append Fields (29): There were more than 16 records in the source."

I am looking forward to your answer. It would be hard to share the data because of the company privacy  

Best regards 

Mahmoud

[atcodedog05]

Hi @Mahmoud_Turki 

Set the highlighted config of append tool as "Allow all append"

Hope this helps : )

[Mahmoud_Turki]

Thank you so much

[atcodedog05]

Happy to help : ) @Mahmoud_Turki 

If my response helps please don't forget to mark my post as solution.

Cheers and have a nice day!