Exclude data with zero sum Qty

[tangrimohit]

Hi All,

I need help in delete/exclude rows where the sum of Qty is zero, Sum needs to be done based on employee and VIN. Also the final output should only have latest month value. 

I have attached Alteryx workflow with input and desired output. 

Appreciate the help.

[ShankerV]

Hi @tangrimohit 

I can propose 2 solutions.

Solution 1:

Please find the expected solution..

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @tangrimohit 

Step 1: Input

Step 2: Multirow tool

step 3: Filter tool

Step 4: Select tool

Expected result:

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[ShankerV]

Hi @tangrimohit 

With the help of multirow tool, we are identifying the cancelled order.

With the help of filter too, we are eliminating the cancelled order details.

The expected output is reached.

Select tool is used just to eliminate the temp column used for processing.

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[ShankerV]

Hi @tangrimohit 

Solution 2:

Usage of sample tool, with below configuration

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[tangrimohit]

Shanker V Thanks a lot. I will be posting a lot of questions. You are amazing

[syamvg · Accepted solution]