The World Statistics Day celebration continues here in the Community. We all need reliable data for sound decision making. Do you have a data source that you trust most? Head over to Discussions to tell us about it.
Choose Language Hide Translation Bar
Highlighted
rs
rs
Level II

How do I index repeated values on Table when values are nested?

Hi All,
 
I have a table in JMP such as:
ItemNum
Level
Result
Item1
A
98x
Item1
B
23x
Item1
C
47x
Item1
C
13x
Item1
A
22x
Item1
B
12x
Item1
A
18x
Item1
B
2x
Item1
C
50x
item2
A
80x
item2
B
34x
item2
C
70x
item2
C
51x
item2
A
65x
item2
B
5x
item2
A
100x
item2
B
79x
item2
C
67x
 
I would like to transpose it into.
ItemNum
A
B
C
Item1
98x
23x
47x
Item1
22x
12x
13x
Item1
18x
2x
50x
item2
80x
34x
70x
item2
65x
5x
51x
item2
100x
79x
67x
 However, the JMP transpose platform produces this:
 
ItemNum
Label
A
B
C
Item1
Result
18x
2x
50x
item2
Result
100x
79x
67x
 
How could I get the transpose platform to take into account that item1 and item2 repeat more than one time?
 
Thank you
 
 
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
rs
rs
Level II

Re: How do I index repated values on Table when values are nested?

2 REPLIES 2
Highlighted
txnelson
Super User

Re: How do I index repated values on Table when values are nested?

Use

     Tables==>Split

and setup the dialog box like:

split.PNG

Which gives the resulting data table

split2.PNG

Jim
Highlighted
rs
rs
Level II

Re: How do I index repated values on Table when values are nested?

Article Labels

    There are no labels assigned to this post.