Developer Tool Guide

Back Next

Sorting Column Data

Use sorted ports to sort column data in a customized data object or relational data object instance. When you use the data object as a read transformation in a mapping or mapplet, you can pass the sorted data to transformations downstream from the read transformation.

Open the customized data object or relational data object instance.

Select the

Read

view.

The following figure shows the

Read

view of a customized data object that is open in the editor:

Select the Output transformation.

Select the

Query

properties.

Select the simple query.

Click

Edit

next to the

Sort

field.

The

Sort

dialog box appears.

To specify a column as a sorted port, click the

New

button.

Select the column and sort type, either ascending or descending.

Repeat steps Using Sorted Ports and Using Sorted Ports to select other columns to sort.

The Developer tool sorts the columns in the order in which they appear in the

Sort

dialog box.

Click

In the

Query

properties, the Developer tool displays the sort columns in the

Sort

field.

Click

Validate

to validate the sort syntax.

Save the data object.

Sorted Ports

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

Developer Tool Guide

Developer Tool Guide

Sorting Column Data

Sorting Column Data