Column Group Option

 

Sometimes two or more columns have an association with each other and need to be masked together.

For example, suppose we have two columns, 'city' and 'postalcode', and we wanted to shuffle them together. If we used two independent Shuffle masks then we would end up with city names being shuffled to rows with the wrong postalcode.

Similarly, A DataSet mask can read multiple columns from the same row in the DataSet (CSV) file and use these to mask multiple columns on the same row of a table

Therefore, to create such an association between multiple columns, DataVeil provides the Column Group feature.

All columns in a Column Group must be in the same table.

You can access the Column Group editor by setting focus to the required table (click on the table node in the Project explorer tree) and open the Masking view.

Column groups tab

 

Click on the 'Create...' button to create a Column Group and use the 'Add' button to add columns to the new Column Group. The screen capture below shows that the 'city' and 'postalcode' columns have been added:

 Column group definition

 

After you click 'OK' the new Column Group is added to the table's Column Group tab.

Column group example

 

Now, whenever you add a mask to one of the Column Group columns you will be shown only those masks which are compatible with Column Groups. The other masks shall be disabled. Only the DataSet, Preserve and Shuffle masks are compatible with masking multiple columns together on a selected row.

Column group data masks