Can Alteryx differentiate between items status types?

[ivoiculescu2020]

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

[Deano478]

hey @ivoiculescu2020 can you provide some sample/dummy data so we can try and get a solution together? 

[ivoiculescu2020]

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

[Raj]

How will you know the Quantity if it is not in the Input data

please simplify the Question to give the solution.

[ivoiculescu2020]

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

[Raj]

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?