Arrange Tool

The Arrange tool allows you to manually transpose and rearrange your data fields for presentation purposes. Data is transformed so that each record is turned into multiple records and columns can be created by using field description data.

Configuration Properties

To better describe the configuration of this tool, we will focus on an example business case:

Example: County population data by age and by sex

Data Before:

Name

AGEFCY0049

AGEFCY50+

AGEMCY0049

AGEMCY50+

Adams County

156505

48372

170303

44428

Alamosa County

5524

2114

5709

1921

 

Data After:

Name

Variable Description

Male

Female

Adams County

Population Age 0-49

170303

156505

Adams County

Population Age 50+

44428

48372

Alamosa County

Population Age 0-49

5709

5524

Alamosa County

Population Age 50+

1921

2114

 

  1. Specify the Key field(s) of your data stream. Click All to select all fields or click Clear to deselect all fields.

  2. Construct the output fields.

    1. From the Column drop down, click Add. The Add Column dialog opens.

      • Column Header: Type the name of the new column of data.
      • Example: Female

      • Fill in Description Column: Adds a new column with your description value of the selected fields. Specify None and no description Column will be added.
      • Example: Add New Description

      • Description Mode: How the description field is populated. Choices include:
        • Take from Descriptions: The description for the field is used from its metainfo.
          • Example: the descriptions for the fields are: Female Population Age 0-49, Female Population Age 50+

        • Take from Field Names: The field name is used.
        • Leave Empty: The description is left empty.
      • Description Header: Type the desired column header name for the new Description field.
      • Example: Variable Description

      • Fields: Select the fields that will make up the data values for the new column of data. Use the All and Clear buttons to select All fields or Clear your selection.

      • Example: Selected fields were AGEFCY0049 and AGEFCY50+

    2. Additional Column Menu items include:

      • Delete: deletes the entire column of the highlighted record.
      • Rename Column Header: prompts the user with a rename box for the column of the highlighted record.
      • Replace Highlighted Descriptions: prompts the user with a search and replace box and replaces the text as specified for the highlighted records.
      • Replace Entire Column Descriptions: prompts the user with a search and replace box and replaces the text as specified for the entire description column.
      • Left/Right arrows: re-orders the selected columns left or right.
    3. Row Menu Items Include:

      • Add: Adds a blank row. User can type the description manually and use the drop down to select a field.
      • Delete: Deletes a selected row.
      • Up/Down arrows: re-orders the selected rows up and down.

Related Topics Link IconRelated Topics