Splicing Different Texts in the Same Column

Preview

This document introduces how to splice different texts in the same column and separate them with the symbol (.).

Implementation Method

Use Group Summary to splice all secondary channels belonging to each first class channel.

Add a Formula Column and use the SUBSTITUTE function to modify the splicing symbol.

Sample data: Public Data > Industry Data > Internet > Internet Channel Statistics.

Creating an Analysis Subject

Create an analysis subject, add the public data Internet Channel Statistics, and select all fields by default.

Click Filter and filter out null data of the First class channel name field.

Splicing

Click Group Summary, drag First class channel name into Group, drag Secondary channel name into Total, and change its Summary Method to Combine as Character String.

Modifying the Splicing Symbol

Click Formula Column and name the added column as Replacing Splicing Symbol. Enter the formula SUBSTITUTE(Secondary channel name,"/",".") and click OK.

Rename the analysis subject and click Save and Update.

For the demonstration, see section "Preview".