Step 3. Define Table Properties to Normalize an Array
Step 3. Define Table Properties to Normalize an Array
In this step, you define table properties that normalize an array in a data map.
Open the demo.map2array data map.
On the
Data Map
tab in the
Resource Explorer
, right-click the RECORD_IN table and click
Properties
.
The
Table Properties - Definition
dialog box appears.
In the
Column Generation
list, select
Refresh with missing columns
.
Because the record on which the table is based contains new fields, corresponding columns are added to the table.
Click
OK
.
On the
Data Map
tab in the
Resource Explorer
, right-click the RECORD_IN table and click
Properties
.
The
Table Properties - Definition
dialog box appears.
In the
Table Properties - Definition
dialog box, complete the following actions:
In the
Column Generation
list, select
Apply array format changes
.
Because the record on which the table is based contains changed fields that are defined as arrays, those changes are reflected in the corresponding columns in the table.
In the
How do you want to handle multiple instances of selected record
list, select
New Row
.
This action causes PowerExchange to display a new row for each occurrence in the array in a database row test.