Edit Column Mappings

Column mappings define the relationship between columns in lists and columns that appear in reports.

The column mapping section also allows you to map a column to another column. There are three main scenarios where you might need to remap a column.

Column Mapping Scenarios

The scenarios where you would need to do this include:

Mapping two columns with a different name to the same column

If you have two columns in two different lists that perform the same function, but have different internal names, you can map them to a single column.

For example, the Assigned To column is called AssignedTo in most lists; however, in the Project Deliverable Library, the Assigned To column has an internal name of AssignedToUser.

Mapping two columns with the same name to different columns

If you had two columns in two separate lists that had the same name, but actually performed different functions, you could distinguish between them by mapping one of them to a different name – otherwise they will roll up under the same column in the report.

Mapping a column with a number as a leading character to one that is acceptable to the DataTable

Report column names cannot have a number as a leading character. If a column has a number as a leading character you will have to map it to a column that does not have a number as a leading character (e.g. from 07_Feb_Sales to Feb_Sales_07).

To update the column mappings:

Navigate to the BrightWork Reporter Library and click Report Editor on the menu of the report you want to edit.

Click Edit Column Mappings in the List Query Templates section of the list whose column mappings you want to edit.

Note:

The purpose of the column mappings page is to map columns in the report to columns in the List Query Template. To be able to map a column in a List Query Template you must first add the column to the report.

If you have specified a context, you will be able to select a column from the List menu on the left.

If a column in the list and in the Columns section have the same internal name they will be automatically mapped (you will still have to select the column to include it in the report).

Specify the Context Settings.

Select Include Project Statement Columns (optional) if you would like to create a Project Statement join.

Select the columns you would like to include.

If necessary, specify a new internal column name so as to map the column to another column in the Columns section. You will need to know the internal column name used in the Columns section.

Click Update.