Arrange Tool
Use Arrange to manually transpose and rearrange your columns for presentation purposes. Data is transformed so that each row is turned into multiple rows, and you can create new columns using column description data.
Tip
This tool has a One Tool Example. Visit Access Sample Workflows to learn how to access this and many other examples directly in Designer Cloud.
Configure the Tool
In Columns to Group By, check columns from your data stream. Check All to select all columns, or search for a specific column using the search bar.
Create New Column
Select the plus icon ( + ) to open the configuration window to create and customize your new column.
New Column Header: Enter the name of the new column of data.
Populate with Values From: Select the columns that contain the data to fill your new column. Check CheckAll to select all columns or search for a specific column using the search bar.
Add Label Column: Use this checkbox to specify labels for your arranged data. The Label Column is added next to your new column.
Label Column Header: Enter the name of the new label column.
Populate With: How the label column is populated.
Column Headers: Populated with the column name.
Empty Values: Not populated.
Select Create Column to add the new column to the Output Table in the Arrange tool configuration window.
Output Table
After a new column is created, it appears in the Output Table in the Arrange tool configuration window.
To adjust columns, select a column and select...
Delete: Delete the entire column of the highlighted row.
Add: Use the plus-sign button to add a blank column. This brings up the Create New Column configuration window.
To adjust rows, select a row, then select...
Add: Use the plus-sign button to add a blank row. Manually enter the label column, and use the dropdown to select the column you want to Populate with Values From.
Delete: Delete the selected row.
To arrange existing data...
Use the up and down arrows to reorder selected rows.
Use the left and right arrows to reorder selected columns.