Home > Features > Data > Denormalize
Denormalize
This feature, found on the Data tab, can be used to copy data from one row to subsequent rows where fields are empty.
Example
The User and System fields were denormalized in the example below.
As a result, anytime the User or System fields are blank, ReportsDNA will populate them with the value from the previous row (see data in blue, which was populated by ReportsDNA).
|
Original Data
|
|
|
User
|
System
|
Privilege
|
|
Aliozides
|
DB1
|
Read
|
|
|
|
Update
|
|
Aliozides
|
DB2
|
Create
|
|
Gopidies
|
DB3
|
Create
|
|
|
|
Update
|
|
|
DB4
|
Read
|
|
|
|
Delete
|
|
|
Denormalized
|
|
|
User
|
System
|
Privilege
|
|
Aliozides
|
DB1
|
Read
|
|
Aliozides
|
DB1
|
Update
|
|
Aliozides
|
DB2
|
Create
|
|
Gopidies
|
DB3
|
Create
|
|
Gopidies
|
DB3
|
Update
|
|
Gopidies
|
DB4
|
Read
|
|
Gopidies
|
DB4
|
Delete
|
|
See also