Check Row by Row

[BRRLL99]

I have following dataset 

Input :

NA	AMT	Brackets
CA	1400.00	1400.00
CA	-1400.00	(1400.00)
4	1400.00	1400.00

Expected Output:
Rules:
1. positive and Negative Same Amount should be matched

2. String and number should be Matched, string and string should not be matched, same with number
in this example string is CA it be can be anything NA, RS etc same with number

NA	AMT	Brackets	match
CA	1400.00	1400.00
CA	-1400.00	(1400.00)	M
04	1400.00	1400.00	M

[RaphaelSilva]

Have you tried creating conditioning labels for the rules you want to match and then join then afterwards?
Like, simplify the data with new formula fields, "is that string or number", is that "negative or positive", "Are values same amount"... then join based on the rules you want, reducing the number of unique values the join tool deal with.

[BRRLL99]

can you show me how it is done?

I am not aware of conditional labels

[RaphaelSilva]

I mean, using formula tool you can create labels

IF [AMT] >= 0 THEN "Positive Value" ELSE "Negative Value"
IF [AMT] = [Brackets] THEN "Value Match" ELSE "Different Values"

Things like that, matching with your rules
Then on Join tool you join by those labels

[BRRLL99]

I tried your logic it's not working

IF [AMT] = [Brackets] THEN "Value Match" ELSE "Different Values"

by default this value will be in different, How can we join on same dataset?

[RaphaelSilva]

Can you send the sample data and a detailed information on how do you want to match then?
I can create a workflow for you

[BRRLL99]

I have already attached the sample data

Please check that

[RaphaelSilva]

I saw it, I just felt you could have more information about that
About the rules too, it is a bit confusing, if you clarify those points I can make a workflow for you

[BRRLL99]

NA	AMT	Brackets	String/Number
CA	1400.00	1400.00	String
CA	-1400.00	(1400.00)	String	M
4	1400.00	1400.00	Number	M

I have created additional column using formula tool
How can i match string and number when amount is same 

[BRRLL99]

Points are simple

Amount should be same positive and negative 1400 and -1400 and 
NA column should have one string and other number

then those should be marked as "M"