Alteryx Designer Desktop Discussions

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

How to extract policy basis on Net sum

prpanw
8 - Asteroid

Hi Folks,

I have databaset where Policy numbers and net amount in the sheet. How to extract those polcies where sum of net is 0 but  Same policy can have multiple rows with Net amount and it could be cross match. for example below policy has 3 rows where 2nd and 3rd sum is 0. So I need that rows. it can match 1st and 3rd row as well.

Poliyc      Net

A                299

A                  99

A                -99



 

2 REPLIES 2
binuacs
21 - Polaris

@prpanw one way of doing this with the cross join 

image.png

Qiu
21 - Polaris
21 - Polaris

@prpanw 
By Cross match, you mean for the example below, " 99" can be matched twice with "-99"?

Poliyc      Net

A                299

A                  99

A                -99

A                -99

Labels
Top Solution Authors