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
Level VII

## How to arrange the data of vertical distribution into time-level distribution with JSL?

Hello, everyone!

"Probe.JMP" as an example, statistics its "Start Time" column time does not repeat the number of 417, the maximum of the same time the number of 40.

In this way, I will use Sumary module to clean up JMP and create 40 new columns to get "new.JMP"
Now how to write the data of "DELL_RPNBR" column from vertical distribution to horizontal distribution at the same time to "new.JMP" by JSL.

Thanks!

4 REPLIES 4
Highlighted
Level VII

## Re: How to arrange the data of vertical distribution into time-level distribution with JSL?

dt = Open( "\$SAMPLE_DATA/Probe.jmp" );
Highlighted
Level VII

## Re: How to arrange the data of vertical distribution into time-level distribution with JSL?

I'm just going to do a double loop.
Highlighted
Super User

## Re: How to arrange the data of vertical distribution into time-level distribution with JSL?

I do not understand your question. Are you using Probe.jmp as an example of some data issue that you have with unequal number of estimates for each time period? or ?

This data set has a unique start time for each probe (measurement) of a lot, die (site on the wafer). The fact that there are 40 at the same date is likely an artifact of multiple probers (metrology tools) not contained in this data set.

If I wanted to split by the wafer and keep time information, I would likely create one (or two) columns using the formula Col Minimum( :Start Time, :Lot ID, :Wafer Number ) , call it First Probe.  (And if a 2nd column use the Col Maximum and call it Last Probe) ). Then split  the data

``````Data Table( "Probe" ) << Split(
Split By( :Site ),
Split( :DELL_RPNBR ),
Group( :Lot ID, :Wafer Number, :Process, :First Probe ),
Remaining Columns( Drop All ),
Sort by Column Property
)``````

The result is this

Highlighted
Level VII

## Re: How to arrange the data of vertical distribution into time-level distribution with JSL?

Thank you!

I tried this method instead of going through a loop.

Article Labels

There are no labels assigned to this post.