cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
joann
Level IV

put categories into the same cell with delimiter

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

Screen Shot 2021-10-18 at 1.09.02 PM.png

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

Screen Shot 2021-10-18 at 1.09.59 PM.png

Thanks in advance!

3 REPLIES 3
txnelson
Super User

Re: put categories into the same cell with delimiter

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. 

Jim
joann
Level IV

Re: put categories into the same cell with delimiter

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?

Screen Shot 2021-10-19 at 3.56.40 PM.png

txnelson
Super User

Re: put categories into the same cell with delimiter

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

  1. Create column called Channel
    1. Give it the formula
      Char( Column( 2 ) << get name ) || "_" || Char( Column( 3 ) << get name )

       

  2. Create a column called N Rows
    1. Give it the formula
      :DIRECT + :TRADE

       

  3. It gives you the following data tabletxnelson_0-1634674770654.png

     

  4. Now use the Tabulate platform to create the Display output you want                                                  txnelson_1-1634674860467.png

     

Jim