Hello everyone,
I need your help again: I have a report of lots that have different status types. How can I ask "Alteryx" to show me all different status types for one lot.
For example, lot 123456 has 10 bottles split as follows
5 are available
2 show as On Hold
3 - Awaiting destruction
Which function should I use to ask Alteryx to split this lot into 3 different lines with the quantity next to each of them and its status?
Thank you!
Kind regards,
Ioana
hey @ivoiculescu2020 can you provide some sample/dummy data so we can try and get a solution together?
Hello @Deano478
Thank you for your prompt reply.
I attached this sample report.
The initial data tab shows how the initial report looks like
The possible listing tab shows the same lot but its quantity is split in 3 lines and an Inventory status column would need to be added to reflect the information in the system: quantity has been adjusted as well.
Does it make sense?
Thanks,
Ioana
How will you know the Quantity if it is not in the Input data
please simplify the Question to give the solution.
Hello @Raj
The initial data tab in my sample report would represent the input data. The quantity column (column E) represents the total quantity at the lot level
The possible listing tab represents how the output file should look like.
I hope it makes sense.
Thank you for your help!
Regards,
Ioana
I was asking the same how do you know
5 are available
2 show as On Hold
3 - Awaiting destruction
is there any another sheet for that?