How to realize If table BB, column C=="Y", then table AA column D result will fill in "Y" too accordingly. Other all values no change

[#1]

Would you use 2 table as a example to show how to realize:

If table BB, column C=="Y", then table AA column D result will fill in "Y" too accordingly. Other all values no change.

My JMP version is V14. Thanks for your help

[#2]

Here is a simple script that performs the task that you specified, or at least how I interpreted what you stated.

Names Default To Here( 1 );
bb = Open( "$sample_data/big class.jmp" );
// Change the Sex column name to "C" to match your example
bb:sex << set name( "C" );

// Create a Blank data table with a column called "D"
aa = New Table( "Change", add rows( 40 ), New Column( "D", character ) );

// If a vlaue in row 2 for column C in table referenced by BB == "F",
// then set the same row value in data table AA column D to "F"
If( BB:C[2] == "F",
	AA:D[2] = "F"
);

// or using a different notation
If( BB[2,3] == "F",
	AA[2,1] = "F"
);

[#3]

Thanks for reply. It works.

But i want realize that if any values in column C=="F", then column D in Table AA =F,  So what should i do? To remove the specific row like [2] information?

I try below scripts, it is not work, thanks. Some times the data table is thousands of rows, i want to see a situation that is no specific rows called out, thanks.

Pls help on this , thanks.

If( BB:C == "F", AA:D = "F" );

[#4]

You could add For Each Row around the if statements. See Scripting Index and For Each Row for more details

For Each Row(
	If( BB:C == "F",
		AA:D = "F"
	);
);

[#5]

Got it thanks

[#6]

I believe the most efficient way to handle this is:

AA:D[ BB << Get Rows Where( BB:C == "F" ) ] = "F";

[#7]

There is also the option to use Loc but it might be a bit more difficult to understand than get rows where:

AA:D[Loc(BB:C << get as matrix, "F")] = "F";