View: merge information from multiple columns in one shared column
You can merge the information that displays in multiple separate columns and display it in one shared column.
Access requirements
You must have the following access to perform the steps in this article:
For more detail about the information in this table, see Access requirements in Workfront documentation.
Considerations when sharing or merging columns
-
You can merge two adjacent columns and display the information from each column separated by a line break, or you can merge the information in two adjacent columns with no separator between the information from each column.
-
You can merge the information from more than two columns by applying the same syntax described in this article to an already shared column and an adjacent one.
-
The
valueformat=HTML
line is mandatory in a shared column. Otherwise, the columns contain no information (they will be blank) when the report is exported from Adobe Workfront. -
Conditional formatting may not be supported in merged columns.
The following exceptions exist:
- When viewing information in Workfront, the formatting of the first column is kept and the formatting for all other columns is ignored if the columns that make up a merged column have different formatting from one another,.
- When exporting the view to a PDF file, conditional formatting applies to the first column in a merged column.
- When exporting the view to an Excel file, merged columns display as separate columns. The individual columns also display their respective conditional formatting rules.
-
Columns with the viewalias attribute can limit the amount of columns that you can merge. To avoid these limits, avoid using the viewalias attribute. If you must include the viewalias attribute in a column, make sure that it is the last item listed in the column.
-
If you export a list with shared columns to an Excel or Tab Delimited format, these columns are separated out in the exported file.
-
When one or both of the columns display a
tile
type field, a forced line-break is automatically introduced in the merged column. For example, Text Fields with Formatting aretile
type fields. In this case, there is a line code oftype=tile
when viewing the columns in Text Mode.
Merge data from two columns without a line break
You can merge the data from multiple separate columns to display it in one column with no breaks or spaces between the values from each column.
To merge data from two columns without a line break:
-
Using text mode for a view, add the following text to the first column you want to merge:
sharecol=true
When you merge the first two columns of a list or report, Workfront precedes each line of text that contains information about the object in the first column with
column.0.
and the lines of text that contain information about the second column withcolumn.1.
.You must precede the column number of the first column with the number of that column. Column counting always starts with the leftmost column of the list or report labeled as
column.0.
.If you share more than one column, ensure you add the column number in the lines of code that contain the sharing information for each column.
Example: The following is the text mode code for a merged column that contains three separate columns, starting with the second column of the list. The merged values are Project Name, Planned Start Date, and Project Owner’s name and there is no break between the three values:
column.1.valuefield=name
column.1.valueformat=HTML
column.1.sharecol=true
column.2.valuefield=plannedStartDate
column.2.valueformat=atDate
column.2.sharecol=true
column.3.valuefield=owner:name
column.3.valueformat=HTML
- Click Save, then Save View.
Merge data from two columns with a line break
Do the following to merge the data from multiple columns to display it in one common column with a line break between the values from each column:
-
Add a third column between the two columns you want to merge.
note tip TIP - The columns you want to merge must be adjacent to each other.
- You must click the first column that you want to merge.
-
Click Switch to Text Mode and add the following code in the middle column that you added in step 1:
value=<br>
valueformat=HTML
width=1
sharecol=true
-
Click the first column and click Switch to Text Mode, then add the following text to the column:
sharecol=true
When you merge the first two columns of a list or report, Workfront precedes each line of text that contains information about the object in the first column with
column.0.
, the column with the sharing information withcolumn.1.
, and the lines of text that contain information about the second column withcolumn.2.
.If the combined column is in the middle of the view, the columns are numbered according to their place in the view. Column counting always starts with the leftmost column of the list or report labeled as
column.0.
.If you share more than one column, ensure you add the column number in the lines of code that contain the sharing information.
Example: The following is the text mode code for a shared column that contains Project Name, Planned Start Date, and Project Owner’s name with a line break. The shared column is the second column of a project view.
column.1.displayname=Project_StartDate_Owner
column.1.sharecol=true
column.1.textmode=true
column.1.valuefield=name
column.1.valueformat=HTML
column.2.value=<br>
column.2.width=1
column.2.valueformat=HTML
column.2.sharecol=true
column.3.valuefield=plannedStartDate
column.3.valueformat=atDate
column.3.sharecol=true
column.4.value=<br>
column.4.width=1
column.4.valueformat=HTML
column.4.sharecol=true
column.5.textmode=true
column.5.valuefield=owner:name
column.5.valueformat=HTML
-
Click Save, then Save View.