BFC
05/16/2020 10:00:00
BFC
4.43
BFC
69
BFC
13
BFC
26
BFC
7
BFC
130
BFC
131
BFC
05/16/2020 11:00:00
BFC
4.43
BFC
71
BFC
13
BFC
8
Simple
=
Is_Date
True
fixed
2020-05-17 10:54:36
0
Y
2020-05-17 10:54:36
2020-05-17 10:54:36
[Is_Date] = "Y"
Field2
MM/dd/yyyy hh:mm:ss
DateTime_Out
Convert Field2 From:
MM/dd/yyyy hh:mm:ss
Field2
Field2
Date
FindWhole
Append
Find and append proper Date treatment
Find and replace proper Date treatment
DateTime_Out
dd/MM/yyyy hh:mm:ss
Date
Convert DateTime_Out To:
dd/MM/yyyy hh:mm:ss
Date
New Field
Int32
4
Empty
IF IsEmpty([Date]) THEN [Row-1:Date]
ELSE [Date]
ENDIF
IF IsEmpty([Date]) THEN [Row-1:Date]
ELSE [Date]
ENDIF
Simple
=
Is_Date
True
fixed
2020-05-17 11:18:01
0
N
2020-05-17 11:18:01
2020-05-17 11:18:01
[Is_Date] = "N"
,
C:\Users\Robert\AppData\Local\Temp\Engine_4372_43bf671175d34866a93552024962d98b_\Engine_560_455e6aa4997942ad987b68c11f99b986_.yxdb
Single
Profile
Field1
Col_ID
Int32
4
Empty
IF [Is_Date]='Y' THEN 1
ELSE ToNumber([Row])+[Row-1:Col_ID]
ENDIF
IF [Is_Date]='Y' THEN 1
ELSE ToNumber([Row])+[Row-1:Col_ID]
...
Horizontal
For_rgarcia2