topic put categories into the same cell with delimiter in Discussions

put categories into the same cell with delimiter

joann — Fri, 09 Jun 2023 00:40:20 GMT

Hi, I'm in tabulate and has the below table:

Is there a way i can make the channel into one cell using existing function, not script? like:

Thanks in advance!

Re: put categories into the same cell with delimiter

txnelson — Tue, 19 Oct 2021 02:23:17 GMT

The only way I know how to do this, would be to use the Summary platform to aggregate the statistics, and then to use the Split platform to create different columns for the Direct and Trade data and then to create new columns to sum the counts and to concatenate the 2 Channels. Finally, you can then take the modified data table and use the Tabulate platform to display the results.

Re: put categories into the same cell with delimiter

joann — Tue, 19 Oct 2021 19:58:37 GMT

Thank you Jim! I'm stuck in the split step you mentioned- how did we get the direct trade in the right place to concatenate while having the numbers in the cells?

Re: put categories into the same cell with delimiter

txnelson — Tue, 19 Oct 2021 20:22:45 GMT

Take the split table you have created and create 2 new columns.

Create column called Channel

Give it the formula

Char( Column( 2 ) << get name ) || "_" || Char( Column( 3 ) << get name )

Create a column called N Rows
1. Give it the formula
```
:DIRECT + :TRADE
```
It gives you the following data table
Now use the Tabulate platform to create the Display output you want