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

Advanced Filter Criteria
Duplicates
Search and Replace