D:\Users\AH0125939\AppData\Local\Temp\Engine_17080_9bd2465f0cd443bbb5c0f362333e7ea0_\Engine_13080_af8bf8d51aaf46bf87b29575e97dce73_.yxdb
Single
Profile
Output2
Output2
RecordID - Ascending
Sort
Person Number - Ascending
Effective Start Date - Descending
Simple
=
test
True
fixed
2022-08-29 19:00:28
0
keep
2022-08-29 19:00:28
2022-08-29 19:00:28
[test] = "keep"
Job Code
New Field
Int32
4
Empty
IF [test]="Keep" &&[job Code]=[Row+1:job Code] Then "" elseif
[test]="Keep" &&[job Code]=[Row-1:job Code] Then "" elseif
[test]="Keep" &&[Row+1:job Code]=[Row-1:job Code]
Then [job code] else "" endif
Job Code
IF [test]="Keep" &&[job Code]=[Row+1:job Code] Then "" elseif...
E6578065
unknown
300000331719190
6578065
2022-05-12
31-Aug-2022
1
030469
E6578065
unknown
300000331719190
6578065
2022-03-14
11-May-2022
3
008188
E6578065
unknown
300000331719190
6578065
2022-03-14
14-Mar-2022
2
030469
6578065
E6578065
unknown
Assignment
2022-03-14
3
2022-09-27
Processing
Sort
Person Number - Ascending
Effective Start Date - Descending
Effective Sequence - Descending
RecordID
1
Int32
6
0
Warning
All
ByName
RecordID
test
V_WString
400
Empty
IF "unique" IN([Row-1:Match],[Match]) Then "Keep" else "dup" endif
IF "unique" IN([Row-1:Match],[Match]) Then "Keep" else "dup" ...
Effective Start Date - Descending
RecordID - Ascending
First
3
First 3
RecordID
final
V_WString
400
Empty
IF "keep" IN([Row+1:test],[Row-1:test],[test]) Then "yes" else "no" endif
IF "keep" IN([Row+1:test],[Row-1:test],[test]) Then "yes" els...
Simple
=
final
True
fixed
2022-08-01 18:59:31
0
yes
2022-08-01 18:59:31
2022-08-01 18:59:31
[final] = "yes"
if ([Effective Start Date]=[Right_Effective Start Date]) then [Effective Sequence]>[Right_Effective Sequence] else
([Effective Start Date]>=[Right_Effective Start Date])
endif
Custom
if ([Effective Start Date]=[Right_Effective Start Date]) then [Effective Sequenc...
Effective Start Date - Descending
Effective Sequence - Ascending
Effective Start Date - Descending
Effective Sequence - Descending
First
1
First 1
First
1
First 1
Horizontal
row