Hi Friends,
I'm working on an Alteryx workflow and currently need some guidance.
I am trying to remove contra entries from a dataset in Alteryx. Where one amount is a positive entry (a debit) and the other amount which offsets it is a negative (a credit). Is there a quick way to identify these entries & comment as "CONTRA" ?
For Example:
In below data set, there are 3 entries with same Customer code, customer GSTIN & Invoice No.
In which 2 set are records were Booked and reversed, and third entries is final entry. Output is highlighted in Red.
| Customer code | Customer GSTN | Inv No | Taxable | Contra |
| 40269779 | 27AADCD0086F1ZW | SI2021-124 | 65,000 | Contra |
| 40269779 | 27AADCD0086F1ZW | SI2021-124 | (65,000) | Contra |
| 40269779 | 27AADCD0086F1ZW | SI2021-124 | 65,000 | |
For your ref i have attached a excel file with sample data & his output.
Thank you
