Hi,
I have a data set that has 500k+ records relating to spare parts repair data. The data contains when the part is sent out for repair and when it returned. based on the way this data needs to feed into another file, it needs to read left to right by month for the portion of the month that this part was out on repair from Jan 23 to dec 24. I would then like to summarize the data so that a part only shows once as a record with 24mons of data going out to the left.
Attached are sample sets of what the data comes in as and then what I am hoping for it to be outputted as. Any help would be appreciated, I would say that I am intermediate level Alteryx user but haven't come across this yet. I have built the above in excel but it is SUPER slow and crashes. Trying to streamline
