Cambodia
Country
Country
1
1
1
1
Hongkong
Cambodia
Cambodia NonPRE
Cambodia PRE
Myanmar
2
2
2
2
2
2
1
123
123
1
1
1
1
1
3
1
1
123
123
123
1
1
123
234
234
123
123
2
2
2
2
2
2
2
12
123
1
1
1
1
12
2
1
23
1
12
1
1
1
123
324
234
1
123
2
2
2
2
22
2
2
12
1
1
1
1
2
3
1
1
1
123
1
12
1
1
213
234
234
123
123
2
2
2
2
2
2
1
3123
213
1
1
1
2
213
1
123
1
1
3
1
1
123
234
234
3
12
2
2
2
2
2
2
11
123
312
1
1
1
3
123
1
123
123
12
1
1
1
1
213
234
23
23
123
2
2
2
2
2
22
1
1
123
1
1
1
3
1
1
12
1
1
1
123
1
232
12
23
4234
123
123
2
2
2
2
2
1
12
1
1
1
1
1
1
1
123
23
1
1
1
23
1
234
Source File
Source File
1
1
1
1
Hongkong
Cambodia
Cambodia NonPRE
Cambodia PRE
Myanmar
2
2
2
2
2
2
1
123
123
1
1
1
1
1
3
1
1
123
123
123
1
1
123
234
234
123
123
2
2
2
2
2
2
2
12
123
1
1
1
1
12
2
1
23
1
12
1
1
1
123
324
234
1
123
2
2
2
2
22
2
2
12
1
1
1
1
2
3
1
1
1
123
1
12
1
1
213
234
234
123
123
2
2
2
2
2
2
1
3123
213
1
1
1
2
213
1
123
1
1
3
1
1
123
234
234
3
12
2
2
2
2
2
2
11
123
312
1
1
1
3
123
1
123
123
12
1
1
1
1
213
234
23
23
123
2
2
2
2
2
22
1
1
123
1
1
1
3
1
1
12
1
1
1
123
1
232
12
23
4234
123
123
2
2
2
2
2
1
12
1
1
1
1
1
1
1
123
23
1
1
1
23
1
234
Source File
Desired Output
Desired Output
Skip
4
Skip 1st 4
First
1
First 1
Warn
Value
New Field
Int32
4
Empty
IF IsNull([Value]) THEN [Row-1:Value] ELSE [Value] ENDIF
IF IsNull([Value]) THEN [Row-1:Value] ELSE [Value] ENDIF
,
All
IF contains([_CurrentField_],[Country]) THEN [_CurrentField_] ELSE null() ENDIF
IF contains([_CurrentField_],[Country]) THEN [_CurrentField_]...
True
True
"Field1","Field2","Field3","Field4","Field5","Field6","Field7","Field8","Field9","Field10","Field11","Field12","Field13","Field14","Field15","Field16","Field17","Field18","Field19","Field20","Field21","Field22","Field23","Field24","Field25","Field26","Field27"
True
True
True
False
False
False
False
False
False
upper
ByName
Warning
All
ManualDelayed
RightInputRows
Warn
Mapped
Name
Desc
Formula
!contains([Name], "Remove")
Error
Horizontal
Get the specific field based in the cell value