I have a dataset like this coming from two data files:
| ID | Amount | File |
| 2023-01 | 5000 | A |
| 2023-02 | 2000 | A |
| 2023-01 | -5000 | B |
| 2023-02 | -5000 | B |
The ID column are primary keys that indicate an item in the file.
What I want Alteryx to do is to filter out the items the amount of which sums up to 0 in the two files A and B. The output; therefore, should be something like this
| ID | Amount | File | Flag |
| 2023-01 | 5000 | A | Yes |
| 2023-02 | 2000 | A | No |
| 2023-01 | -5000 | B | Yes |
| 2023-02 | -5000 | B | No |
I have tried Summarize and Filter tools, but I just can't get this desired output. Please help out Alteryxers!
