topic Re: 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 in Discussions

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

Theresa — Sat, 10 Jun 2023 23:34:32 GMT

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

Re: 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

txnelson — Sat, 31 Jul 2021 02:29:54 GMT

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

Re: 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

Theresa — Wed, 04 Aug 2021 14:26:50 GMT

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

Re: 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

jthi — Wed, 04 Aug 2021 08:13:07 GMT

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

Re: 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

Theresa — Wed, 04 Aug 2021 23:56:25 GMT

Got it thanks

Re: 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

txnelson — Thu, 05 Aug 2021 00:34:35 GMT

I believe the most efficient way to handle this is:

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

Re: 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

jthi — Thu, 05 Aug 2021 05:13:05 GMT

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