How to Split One table in to two while keeping few rows same.

[#1]

I need to split one table in to two while keeping the SN same but different material in different tables.

[#2]

How is this different than your last post, the attached picture is the same as the last post?

[#3]

Jim,

I apologize. I atteched the wrong picture. I updated the post.

Thanks,

[#4 · Accepted solution]

1. Please take the time to read the document, Discovering JMP available under the Help Pull Down menu
2. Interactively you can accomplish this by:
   1. Select the SN and Material A columns
   2. Go to Tables=>Subset
      1. Select the option, All Rows
      2. Select the option, Selected columns
      3. Click OK
   3. Select the SN and Material B columns
      1. Repeat the steps in step 2 above
3. To do this using JSL

   1. Names Default To Here( 1 );
      dt = Data Table( "Main Table" );
      dtMaterialA = dt << subset( selected rows( 0 ), columns( :SN, :Material A ) );
      dtMaterialB = dt << subset( selected rows( 0 ), columns( :SN, :Material B ) );

[#5]

Thanks Jim