Hello, New to Alteryx trying to figure out how to get the following and hoping someone could help.
I have a list of accounts and annual incomes that I’m trying to filter down but running into an issue when trying to remove duplicates.
I’m trying to get the below sheet as followed…
Row 2 and 3 to keep both of these.
Row 4,5, and 6 something like would like to only keep 1 of the “0” AnnIncomeCode because the Annual Income is the same so looking to delete either row 4 or 6 along with keeping the NULL row in 5 so the only results would be the NULL (row 5) and either 4 or 6.
Row 7 through 10 this one since there are 3 0’s but 2 different AnnIncomeCode would like to only display row 7, 8 and 10 and remove 1 of the duplicate MSTRNUM_ANNIC but then keep the non-duplicate.
The issue I’m running into is the last set of number row 11 through 13, something like this I want to keep anything that is displayed as a -1 (which is a NULL value in ANN_INC_DESC) so for this would like to keep row 11, 12 and 13.
When I remove duplicates both 12 and 13 would be deleted but trying to keep anything with a -1 (as missing Annual income)
Below row 13 is just some additional data for the sheet but quick example row 17-21 something like this would like to keep row 17,18 because they are different remove 19 and 21 because they are duplicates of 18 and keep 20 because its NULL. Also 22 -25 if 22 could be removed and it would only be rows 23,34, and 25.
Hopefully this is enough information any help would be greatly appreciated.
Current List as Is
| MSTR_NUM | Concat_AnnInCode | ANNUAL_INC_DESC | AnnIncomeCode | SSN_and_ANNINC |
| 1242697 | 0,-1 | 50K - 100K | 0 | 1242697/50K - 100K |
| 1242697 | 0,-1 | | -1 | 1242697/ |
| 567894 | 0,-1,0 | 50K - 100K | 0 | 567894/50K - 100K |
| 567894 | 0,-1,0 | | -1 | 567894/ |
| 567894 | 0,-1,0 | 50K - 100K | 0 | 983203/50K - 100K |
| 983203 | 0,0,0,-1 | 250K - 500K | 0 | 983203/250K - 500K |
| 983203 | 0,0,0,-1 | 50K - 100K | 0 | 983203/50K - 100K |
| 983203 | 0,0,0,-1 | 250K - 500K | 0 | 983203/250K - 500K |
| 983203 | 0,0,0,-1 | | -1 | 983203/ |
| 7329331 | 0,-1,-1 | 50K - 100K | 0 | 7329331/50K - 100K |
| 7329331 | 0,-1,-1 | | -1 | 7329331/ |
| 7329331 | 0,-1,-1 | | -1 | 7329331/ |
| 456833 | -1,0,0 | | -1 | 456833/ |
| 456833 | -1,0,0 | 50K - 100K | 0 | 456833/50K - 100K |
| 456833 | -1,0,0 | 50K - 100K | 0 | 456833/50K - 100K |
| 295472 | 0,0,0,-1,0 | 25K - 50K | 0 | 295472/25K - 50K |
| 295472 | 0,0,0,-1,0 | 50K - 100K | 0 | 295472/50K - 100K |
| 295472 | 0,0,0,-1,0 | 50K - 100K | 0 | 295472/50K - 100K |
| 295472 | 0,0,0,-1,0 | | -1 | 295472/ |
| 295472 | 0,0,0,-1,0 | 50K - 100K | 0 | 295472/50K - 100K |
| 67438 | 0,-1,-1 | 50K - 100K | 0 | 67438/50K - 100K |
| 67438 | 0,-1,-1 | 50K - 100K | 0 | 67438/50K - 100K |
| 67438 | 0,-1,-1 | | -1 | 67438/ |
| 67438 | 0,-1,-1 | | -1 | 67438/ |
Would like it to display the following
| MSTR_NUM | Concat_AnnInCode | ANNUAL_INC_DESC | AnnIncomeCode | SSN_and_ANNINC |
| 1242697 | 0,-1 | 50K - 100K | 0 | 1242697/50K - 100K |
| 1242697 | 0,-1 | | -1 | 1242697/ |
| 567894 | 0,-1,0 | | -1 | 567894/ |
| 567894 | 0,-1,0 | 50K - 100K | 0 | 983203/50K - 100K |
| 983203 | 0,0,0,-1 | 250K - 500K | 0 | 983203/250K - 500K |
| 983203 | 0,0,0,-1 | 50K - 100K | 0 | 983203/50K - 100K |
| 983203 | 0,0,0,-1 | | -1 | 983203/ |
| 7329331 | 0,-1,-1 | 50K - 100K | 0 | 7329331/50K - 100K |
| 7329331 | 0,-1,-1 | | -1 | 7329331/ |
| 7329331 | 0,-1,-1 | | -1 | 7329331/ |
| 456833 | -1,0,0 | | -1 | 456833/ |
| 456833 | -1,0,0 | 50K - 100K | 0 | 456833/50K - 100K |
| 295472 | 0,0,0,-1,0 | 25K - 50K | 0 | 295472/25K - 50K |
| 295472 | 0,0,0,-1,0 | | -1 | 295472/ |
| 295472 | 0,0,0,-1,0 | 50K - 100K | 0 | 295472/50K - 100K |
| 67438 | 0,-1,-1 | 50K - 100K | 0 | 67438/50K - 100K |
| 67438 | 0,-1,-1 | | -1 | 67438/ |
| 67438 | 0,-1,-1 | | -1 | 67438/ |
