In This Topic
Transpose Row to Col command converts the data structure of the app from any rows (records) of input data to columns (fields).
Transpose Row to Col command cannot be used for a table. If input data contains a table, it is disposed of on executing the command. If you want to perform Transpose Row to Col command on a table, execute it after expanding the table using Convert Table to Record command.
Settings
| Setting |
Description |
| 1. Select the field that has the field labels you want |
Select the field that contains the value to be converted to a column. |
| 2. Select the fields that identify a record |
In combination with value of the field to be converted to a column, select the field name that contains a value that uniquely identifies the row. You can specify multiple such fields. |
| 3. Name a new field to create |
Enter name of the new column (field) to be created after conversion. |
| 4. Which label identifies the records that belongs in this new field? |
Enter a value identifying the new column that is stored in the field to be converted to column. |
| 5. Select what field values will populate this new field |
Select the field that contains the value to save in the new column. |
Example
This example demonstrates how to convert budget data of a department which is saved monthly as row data (records) into columns (fields).
Input Data
Command Settings
| 1. Select the field that has the field labels you want |
2. Select the fields that identify a record |
| Month |
・Department
・Account |
| 3. Name a new field to create |
4. Which label identifies the records that belongs in this new field? |
5. Select what field values will populate this new field |
| April |
4 |
Budget |
| May |
5 |
Budget |
| June |
6 |
Budget |
| July |
7 |
Budget |
| August |
8 |
Budget |
| September |
9 |
Budget |
| October |
10 |
Budget |
| November |
11 |
Budget |
| December |
12 |
Budget |
| January |
1 |
Budget |
| February |
2 |
Budget |
| March |
3 |
Budget |
Settings Page
Execution Result
