Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Clear double entries

maxiemens
7 - Meteor

Hey guys I have the following problem:

 

maxiemens_0-1599033228342.png

 

There are two movement types: 201 (delivered) and 202 (recalled)

 

Order 1234 was delivered but then recalled it means 0 parts were delivered (see above)

 

so what I want to see is this: 

 

maxiemens_1-1599033406783.png

 

because I am only interested in the delivered items

5 REPLIES 5
JosephSerpis
17 - Castor
17 - Castor

Hi @maxiemens came up with a couple of ways you could do this let me know what you think?

grazitti_sapna
17 - Castor

Hi@maxiemens, try this,I hope this helps.

grazitti_sapna_0-1599034416929.png

 

Thanks.

 

 

Sapna Gupta
maxiemens
7 - Meteor

The solution with the Duplicate tool is awesome thanks 🙂 

maxiemens
7 - Meteor

Hey how does it work in this Case? 

 

maxiemens_0-1599557450944.png

 

grazitti_sapna
17 - Castor

Hi @maxiemens , try this.

grazitti_sapna_0-1599559289292.png

Alternate Solution-

grazitti_sapna_0-1599559445645.png

 

Thanks.

Sapna Gupta
Labels