Defining Table Properties in a Data Map to Normalize an Array

Back Next

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

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.

Click

For more information about the

Table Properties - Definition

dialog box, see Table Properties - Definition.

Defining Table Properties in a Data Map to Normalize an Array - Example

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Defining Table Properties in a Data Map to Normalize an Array

Defining Table Properties in a Data Map to Normalize an Array

Step 3. Define Table Properties to Normalize an Array

Step 3. Define Table Properties to Normalize an Array