Handling Custom Naming Convention

With the Cross-Channel Wizard, you can handle your naming convention. To do so, you can use the following formula:

The expression inside the brackets consists of two parts:

• ‍Delimiter - character after which the field value is trimmed;‍
• Field - field for trimming.

Step 1. Check out your naming convention

Open your table and determine the delimiter required for your field.

Step 2. Create a new field

Create a new field by clicking the + Field button. Give a name to the new field.

Step 3. Set a custom formula splitByChar in the required field

Open the Custom formula window and in the Set value or formula field enter splitByChar formula.

Note that if you want to handle the field for separate data sources, you need to set a custom formula in the columns with the data sources you need.

Step 4. Check the results

Before you save your model, check it. To do this, click the Preview button and you will see what your table will look like without saving it.

Step 5. Save the model

Click the Run and Save button to save the table.