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, select columns from your data stream. You can also Select All columns or search for a specific column using the search bar.
Create New Column
Select Add Column to open the configuration window to create and customize your new column.
Output Column Name: 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. You can also Select All columns or search for a specific column using the search bar.
Add Label Column: Select this checkbox to specify labels for your arranged data. The Label Column is added next to your new column.
Label Column Name: Enter the name of the new label column.
Populate With: Select how the label column is populated.
Column Names: Populated with the column names you selected above.
Empty Values: Not populated.
Enter Label: Enter a custom lable.
Select Create Column to add the new column to the Output table in the tool configuration window.
Output Table
After you create a new column, it appears in the Output table in the tool configuration window.
To adjust columns, select a column and then select...
Add: Select the plus sign icon (+) to add a blank column. This opens the new column configuration window.
Delete: Select the trash icon to delete the entire column of the highlighted row.
To adjust rows, select a row, then select...
Add: Select the plus sign icon (+) to add a blank row. Manually enter the label column (if applicable) and use the dropdown to select the column you want to Populate with Values From.
Delete: Select the trash icon to 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.