nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How can i Specific value copy?

Song

Names Default To Here( 1 );
db_test  = Open( "$SAMPLE_DATA/big class.jmp" );


mycol =  Column("age");
xf = db_test << get rows where(contains(column(1)[],"O"));
xm = db_test << get rows where(contains(column("sex")[],"M"));
xa = db_test << get rows where( mycol[]== 13);
show (xf, xm, xa);


New Column( "Select", "Character", <<Set each Value(:sex["xf"]) );

I'd like to select specific cells and add new column only specific value.

Above the script doesn't work.

How can i make it work?

Accepted answers

txnelson

I believe this is a simpler way to do what you want

Names Default To Here( 1 );
dt = Current Data Table();

dt << New Column( "Select",
	character,
	formula(
		If( Contains( As Column( 1 ), "O" ),
			:name,
			"Pass"
		)
	)
);

All comments

Mark_Bailey

I would separate the creation of the new column and populating the new column into two steps in this case. Here is a simplified version of your example to illustrate my approach.

Names Default To Here( 1 );

dt = Open( "$SAMPLE_DATA/big class.jmp" );

xf = dt << Get Rows Where( Contains( Column( 1 )[], "O" ) );

New Column( "Select", "Character" );
dt:Select[xf] = "M";

Song

@Mark_Bailey

Thanks a lot for your help!

I have one more question. How can i write the name? not M

Below script didn't work.

Names Default To Here( 1 );

dt = Open( "$SAMPLE_DATA/big class.jmp" );

xf = dt << Get Rows Where( Contains( Column( 1 )[], "O" ) );

New Column( "Select", "Character" );
dt:Select[xf] = dt:name[xf];

xy = dt << Get Rows Where(
 	Is missing( :Select)
 );

dt:Select[xy] = "Pass"

txnelson

I believe this is a simpler way to do what you want

Names Default To Here( 1 );
dt = Current Data Table();

dt << New Column( "Select",
	character,
	formula(
		If( Contains( As Column( 1 ), "O" ),
			:name,
			"Pass"
		)
	)
);