Exclude data with zero sum Qty

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.

Sum and clean.yxmd

Tips and Tricks

Join

Preparation

Expression

Data Investigation

Accepted answers

ShankerV

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

syamvg

Sum and clean v1.yxmd

All comments

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

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

Sum and clean v1.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703