I have following data with 100's of rows
a sample has been attached
Input :
| deal Type | Amount | ID | Positive/ Neg | Abs Amount | String/Number |
| CA | 100 | 1 | Positive | 100 | string |
| 7 | -100 | 1 | Negative | 100 | number |
| CA | 100 | 1 | Positive | 100 | string |
| AB | 200 | 2 | Positive | 200 | string |
| 4 | -200 | 2 | Negative | 200 | number |
| 4 | 200 | 2 | Positive | 200 | number |
| CA | -200 | 2 | Negative | 200 | string |
Expected Output:
Group By ID, +ve amount should be matched with -ve amount and string/Number should not be same
| deal Type | Amount | ID | Positive/ Neg | Abs Amount | String/Number | match |
| CA | 100 | 1 | Positive | 100 | string | m |
| 7 | -100 | 1 | Negative | 100 | number | m |
| CA | 100 | 1 | Positive | 100 | string | |
| AB | 200 | 2 | Positive | 200 | string | m |
| 4 | -200 | 2 | Negative | 200 | number | m |
| 4 | 200 | 2 | Positive | 200 | number | m |
| CA | -200 | 2 | Negative | 200 | string | m |
