topic Re: Splitting columns that have multiple items in Discussions

Splitting columns that have multiple items

kwmcm — Thu, 15 Aug 2019 15:27:36 GMT

I have attached two simple data tables of something I'm sure JMP can do, but I'm not sure how.

I have a much larger data table that has multiple columns with multiple names in them.

In my Example Before, it's simple, two names in under Name column.

What I'd like to do is split the two names, to make two lines- Example After. I highlighted the rows that were "updated"

I don't need to split anything else.

Is this possible???

Re: Splitting columns that have multiple items

Dan_Obermiller — Thu, 15 Aug 2019 17:00:30 GMT

This could probably be done more efficiently with a script, but here is an interactive approach that will work regardless of the number of names in the Before table's Name column.

Highlight the Name column and choose Cols > Utilities > Text to Columns.

In the delimiter box type a comma "," and click OK. This will give you two new columns, Name 1 and Name 2.

Now Tables > Stack. The Stack Columns are Name 1 and Name 2. For convenience make the Stacked Data Column be called Final Name. Make sure the Non-stacked columns are set to Keep All, and click OK.

The resulting table will have some blank cells in the Final Name column. Right-click on one of those cells and select Select Matching Cells. Now go to Rows > Delete Rows. You can then get rid of the original Name column and Label column, if you wish.

Re: Splitting columns that have multiple items

kwmcm — Thu, 15 Aug 2019 17:26:19 GMT

Thank you! That is exactly what I was looking for!