This document introduces how to splice different texts in the same column and separate them with the symbol (.).
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.
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.
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.
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".
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy