First Name
A
B
User name
AB123
User email
ab123@gmail.com
Permission
Product
Service
PName
Value
Reports
Admin
creation
input
TRUE
File
Admin
creation
input
TRUE
First Name
C
D
User name
CD456
User email
CD456@gmail.com
Permission
Product
Service
PName
Value
Reports
Admin
creation
input
TRUE
File
Admin
creation
input
TRUE
Contains([Field1],"User name") OR
Contains([Field1],"User Email") OR
Contains([Field1],"Name")
Custom
Separate tall data from wide data
Contains([Field1],"User name") OR
Contains([Field1],"User Email") OR
Contains([...
F1
RecordID
Int32
4
Empty
IF [Field1]="First Name" THEN [Row-1:RecordID]+1
ELSE [Row-1:RecordID] ENDIF
Assign a RecordID for each set of rows
IF [Field1]="First Name" THEN [Row-1:RecordID]+1
ELSE [Row-1:...
,
Reformat to wide data
Reformat to wide data
Warn
Convert wide data to tall data
Convert wide data to tall data
Value
New Field
Int32
4
Empty
IF IsNull([Value]) THEN [Row-1:Value] ELSE [Value] ENDIF
Fill Nulls
IF IsNull([Value]) THEN [Row-1:Value] ELSE [Value] ENDIF
RecordID - Ascending
Name - Ascending
Value - Descending
Warning
All
ByName
Blend data back together
Blend data back together
Simple
!=
Permission
True
fixed
2021-10-13 14:52:20
0
2021-10-13 14:52:20
2021-10-13 14:52:20
Permission
[Permission] != "Permission"
FirstRow
Warn
C:\Users\kkincaid\AppData\Local\Temp\Engine_10956_58b1b5fd025d40fca5aa245fef84e5c2_\Engine_11636_c2b9e2012e854a0281e78e2ad3bfdd53_.yxdb
Single
Profile
Permission
Original Method
Sort
1
Int32
6
0
C:\Users\kkincaid\AppData\Local\Temp\Engine_4716_7c7e0dff239e4be8929cef46329e242d_\Engine_11636_e9aa3bef2b9e4a8a880849644e56e0e6_.yxdb
Single
Profile
,
ID Column
Record ID
Int32
4
Empty
if [Min_Sort]=1 then [Row-1:Record ID]+1 else [Row-1:Record ID] endif
if [Min_Sort]=1 then [Row-1:Record ID]+1 else [Row-1:Record I...
Sort - Ascending
Horizontal
2021-10-13 Reformatting Wide and Tall Data