The Columns Transformation step in the source creation wizard provides options to transform process columns before creating the source, including removing columns, anonymizing columns, and creating new columns by combining existing columns.

Removing columns

When you upload a data source, Pega Process Mining imports all columns by default. If any of the columns are not necessary for analysis, you can remove them from the source. Removing unecessary columns reduces the volume of data processed and might also increase the overall performance of the application.

To remove a column, click the More icon and select Remove column, as shown in the following figure:
Clicking the More icon on a column opens a menu that displays the Remove column option.
Remove column option
If you remove a column, it is no longer part of the source and appears as grayed out:
The removed Type column is grayed out.
Removed columns are grayed out

Anonymizing columns

To protect sensitive data, such as confidential user data, you can anonymize data as soon as the system creates the source by clicking the More icon and selecting Anonymize column, as shown in the following figure:
Clicking the More icon on a column opens a menu that displays the Anonymize column option.
Anonymize column option
After you anonymize a column of data, the system replaces the actual data with asterisks, as shown in the following figure:
After anonymizing the ID column, the data in this columns shows as asterisks.
Anonymized data in a column

Adding new columns

You can create a customized column by combining columns in the source using the following combination methods:
  • Concatenate two columns to form a new one while leaving the original columns in place
  • Merge two columns into a new column and then remove the original columns
Begin the creation process by clicking Add New Column in the columns list, as shown in the following figure:
The Add New Columns option is displayed at the end of the columns preview list.
Add new column
In the Custom Column Creation dialog box, build a new column. In the following figure, the separate City and State columns are merged into a new single column named City-State. You can insert text, such as a dash, next to column names by using the Text field.
In the Custom Column Creation dialog box the separate City and State columns are merged into a single City-State column, and the preview shows as Chicago-Illinois.
Custom Column Creation

Adding new columns demo

The following demo shows how to merge the columns and add a dash between the column names:
An animation shows how to merge the City and State columns and add a dash between column names.
Merging columns and adding a dash between column names