cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
View Original Published Thread

Painting

hcarr01
Level VI
Hello everyone, I have the data table below:
 
undefined

 

I would like to use the divide function, put the weeks in columns (“week”), the types of week in lines (“analysis column”) and in the cells the different types of object (“TYPE”).
 
The problem is that when I use the split function, JMP only enters the cell the last "TYPE" corresponding to the week and the week type as below it should however fill in all the different "TYPE" corresponding:
 
undefined
Here in the cell under "Week 22" we should see "A,B,C,D,E and F"
Here in the cell under "Week 23" we should see "G,H,I,J and K"
 
How could I get around this problem?
Thanks for your help !

This post originally written in French and has been translated for your convenience. When you reply, it will also be translated back to French .

7 REPLIES 7
jthi
Super User


Re: Data Table

You could use SQL query with JMP Query Builder

jthi_0-1685083743421.png

or Group Listagg Columns add-in also kudo Allow Split to create Multiple Response columns . It can be used to create

jthi_1-1685083814744.png

then you can split this

jthi_2-1685083826057.png

 

Or you can try using JMP's different table platforms to create something like this

jthi_3-1685083909617.png

and then use Combine Columns

jthi_4-1685083948353.png

and do splits, joins, updates as needed

-Jarmo
hcarr01
Level VI

Re: data table

Thank you for the answer !

This post originally written in French and has been translated for your convenience. When you reply, it will also be translated back to French .

dale_lehman
Level VII


Re: Data Table

The suggestions from jthi give you lots of options.  But if all you need is to get what you describe, you can just use Table Split, split by week and split the TYPE column.  You get the attached table.

hcarr01
Level VI

Re: data table

Thank you for your reply !
@dale_lehman Can you be more specific please?

This post originally written in French and has been translated for your convenience. When you reply, it will also be translated back to French .

dale_lehman
Level VII


Re: Data Table

I'm not sure what you mean by more specific, but here is the screenshot of what I described.

hcarr01
Level VI

Re: data table

Putting the analysis column in "Group" is important because I have different analysis columns in the database

This post originally written in French and has been translated for your convenience. When you reply, it will also be translated back to French .

dale_lehman
Level VII


Re: Data Table

In that case, I believe you need at least 2 steps.  First you can use Tabulate with week (after changing it to nominal) and TYPE as rows and your analysis column(s) as columns (if they are continuous, you can put these in the body of the table).  After making that into a data table, you will want to split the TYPE and analysis columns by week.  Attached are 2 screen shots.