StockAge with FIFO logic without iterative macro

Question

Hi the community,

Thank you for helping me

I have 2 data output (I cleansed them using Alteryx ^^) with the following formats:

1. Data of Stock in

2. Data of Stock Out (sale out): each record is an invoice issued, I have more than 200k rows like this

I would like to map them using the First-In-First-Out logic to calculate the Stock Age (difference between Date In and Date Out). The output to be like:

* Model_Type
* Class
* Sales Date
* Sales QTy
* StockIn Date
* Stock Age

I do found a solution on this community using iterative macro. However, I have more than 200k invoice records, which increase the time for using iterative macro to hours

Can this task be done without using iterative macro? Thank you for attempting to help me

PhuongTran52 · Answer

@Luke_C  Thank you so much!

Luke_C · Answer

This weekly challenge is similar, but could help give you some ideas on how to accomplish this using multirow tools.

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-65-Fulfilling-Inventory-Orders/td-p/54168