topic Re: How to Split One table in to two while keeping few rows same. in Discussions

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

ConfidenceOwl94 — Mon, 25 Mar 2024 16:16:26 GMT

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

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

txnelson — Mon, 25 Mar 2024 16:10:30 GMT

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

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

ConfidenceOwl94 — Mon, 25 Mar 2024 16:17:22 GMT

Jim,

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

Thanks,

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

txnelson — Mon, 25 Mar 2024 16:27:21 GMT

Please take the time to read the document, Discovering JMP available under the Help Pull Down menu
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

To do this using JSL

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 ) );

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

ConfidenceOwl94 — Mon, 25 Mar 2024 19:20:36 GMT

Thanks Jim