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:
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
This weekly challenge is similar, but could help give you some ideas on how to accomplish this using multirow tools.
@Luke_C Thank you so much!