Amount Match

[BRRLL99]

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

[JBLove]

@BRRLL99 

After your Input Data, use a Filter Tool to separate your Positive  and Negative numbers.  Then use a Join tool to combine the T and F anchors from the Filter tool.  Based on your data I'm assuming you would join on ID and ABS Amount.  Then you can use a filter on the J output anchor of the Join Tool to identify the rows where the True Path's String/Number value does not match the False Path's String/Number.  You can use the join tool to rename the fields and drop any unnecessary fields.

[Raj · Accepted solution]

@BRRLL99 
please find the workflow attached
please mark as done if this is solved.