101
A101
-100
103
A103
-300
102
A102
-200
102
A102
-200
101
A101
-100
102
A102
-200
102
A102
200
103
A103
-300
103
A103
-300
103
A103
300
103
A103
-300
104
A104
400
104
A104
-400
104
A104
-400
105
A105
-500
106
A106
-600
106
A106
-600
106
A106
-600
107
A107
-700
107
A107
-700
107
A107
700
False
False
"Check Number1","EMPLID","Amount1","Check Number2","Amount2"
False
False
True
True
False
False
False
False
False
upper
RecordID
1
Int32
6
0
C:\Alteryx\Scripts\Engine_816_3069b510fe564f0d9a496f772ab7849e_\Engine_2604_eb99839bcacd44b88d29a9b989a81e7a_.yxdb
Single
Profile
Match Amount 1 to same sign Amount 2
Simple
IsNotNull
Amount1
True
fixed
2021-07-28 16:24:31
0
2021-07-28 16:24:31
2021-07-28 16:24:31
!IsNull([Amount1])
Simple
IsNotNull
Amount2
True
fixed
2021-07-28 16:24:42
0
2021-07-28 16:24:42
2021-07-28 16:24:42
!IsNull([Amount2])
Warn
Match Amount 1 to opposite sign Amount 1
Simple
IsNotNull
Amount1
True
fixed
2021-07-28 16:21:09
0
2021-07-28 16:21:09
2021-07-28 16:21:09
!IsNull([Amount1])
Horizontal
Reconciliation