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

[#1]

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

[#2 · Accepted solution]

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