topic Re: concatenating data of the same category with delimiter in the same cell in Discussions

concatenating data of the same category with delimiter in the same cell

joann — Fri, 09 Jun 2023 00:33:14 GMT

Hi, I have an input as below. How do I generate the summary output as below, using jmp existing function like tabulate or other, concatenating the market with delimiter "|"?

Once we have the output, how to use jmp function to convert the output back to the input format?

Thank you!

input
Code	Market
1	A
2	A
3	A
1	B
5	B
1	C
7	C
7	A


output
Code	Market
1	A\|B\|C
2	A
3	A
5	B
7	A\|C

Re: concatenating data of the same category with delimiter in the same cell

jthi — Mon, 03 May 2021 20:55:34 GMT

With some tinkering around in Tables and Cos menu I might have figured it out. Image instructions follow:

Start:

1. Tables / Split

2. With A, B and C columns selected go to Cols / Utilities / Combine Columns(might want to keep Multiple Response, depending how you use the data)

3. Delete unnecessary colums A, B, C

4. To go back, select Market column and go to Cols / Utilities / Text To Columns

5. Tables / Stack

6. Delete Label column

Re: concatenating data of the same category with delimiter in the same cell

joann — Tue, 04 May 2021 14:59:51 GMT

This works perfectly! Thank you so much!