PaintingHello everyone, I have the data table below:
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:
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 !
You could use SQL query with JMP Query Builder
or Group Listagg Columns add-in also kudo Allow Split to create Multiple Response columns . It can be used to create
then you can split this
Or you can try using JMP's different table platforms to create something like this
and then use Combine Columns
and do splits, joins, updates as needed
Re: Data TableThe 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.
Re: data tableThank you for your reply !
Re: data tableThank you for the answer !
Re: Data TableI'm not sure what you mean by more specific, but here is the screenshot of what I described.
Re: data tablePutting the analysis column in "Group" is important because I have different analysis columns in the database
Re: Data TableIn 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.
