How do I update a column based on values from another column?

Raquel — Mon, 28 Oct 2024 20:19:54 GMT

Hello,

I'm a JMP 18 user.

I want to see if a column contains a specific value and update a different column at the same row where the value was found. The below script does not work. Please assist.

dt = Data Table("Logbook");
StatusList = :Status << Get Values;
For( i = 1, i <= N Items(StatusList), i++,
	If( Contains( StatusList, "Not" ), 
		:Name( "Status Error" )[i] = "Error",	
	, //else
	);
);

Re: How do I update a column based on values from another column?

mmarchandFSLR — Mon, 28 Oct 2024 20:53:05 GMT

If I understand what you are looking for, this script should do it. It only changes :Status Error to "Error" where :Status == "Not" and leaves other entries alone.

Names Default to Here( 1 );
dt = Data Table( "Logbook" );
For Each Row( dt, If( :Status == "Not", :Status Error = "Error" ) );

topic How do I update a column based on values from another column? in Discussions

How do I update a column based on values from another column?

Re: How do I update a column based on values from another column?