topic Re: conditional match with two columns in Discussions

conditional match with two columns

chandankishor66 — Fri, 09 Jun 2023 16:11:17 GMT

Hi JMP users

How to write a script to print a value from column:EtOH % form maximum index of : fermentation Age .

For example: if the maximum fermentation Age for Batch 03-05-2022 is 68 then the EtOH % value (13.45) should be picked and printed to the output column.

Attached a JMP table here.

Looking forward for your suggestion

Regards

Re: conditional match with two columns

txnelson — Sat, 03 Jun 2023 05:48:57 GMT

Here are 2 similar approaches to solve your issue.

Names Default To Here( 1 );
dt = Current Data Table();
dt << New Column( "Output 2",
	formula(
		theMax = Col Maximum( :EtOH %, :Batch );
		If( theMax == :EtOH %,
			:EtOH %,
			.
		);
	)
);

Names Default To Here( 1 );
dt = Current Data Table();
dt << New Column( "Output 3" );
for each row(
	theMax = Col Maximum( :EtOH %, :Batch );
		If( theMax == :EtOH %,
			:Output3 = :EtOH %,
			:Output3 = .
		);
);

Re: conditional match with two columns

chandankishor66 — Sat, 03 Jun 2023 06:46:35 GMT

Thank you, Jim.