- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
How do I update a column based on values from another column?
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
);
);
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How do I update a column based on values from another column?
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" ) );
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How do I update a column based on values from another column?
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" ) );