I'm trying to renaming specific cells after a filter was applied in in a different column. Here is the script that I came up with:
dt = Current Data Table(); df = dt << Data Filter( Add Filter( Columns( :"Sample/Control" ), Where( :"Sample/Control" == "Sample" ) ), ); dt << Go To ( :"Control ID");
I'm only missing the last step, which is to rename the specific cells that are selected. I couldn't find it in any of the guids or help sections.
If I may, I would like to request you to take a step back and explain a little more in detail what you are trying to achieve. When you say you would like to rename a cell - do you mean you want to change the value in a cell of a data table ? If this is correct, then you could achieve that without the use of a data filter. Let us take the following example:
dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); // Open Sample Data Table // Let us assume you want to rename Kaite to Kate and change her age dt << Select Where(:name == "KATIE"); Wait(0.2); // For Demo only SR = dt << Get Selected Rows; dt << Clear Select; :name[SR] = "KATE"; :age[SR] = 13;
Thanks for your response.
I'm working with patient IDs and controls. I would like to to rename all the patient IDs as "sample" but keep the control IDs as they are. I have one column that contains the actual IDs (this is the column in which I would like to change some of the cells - the ones corresponding to patient ID), and another column that differentiates the patient IDs and controls. Under this column, there is either "sample", "positive control" or "negative control" in each cell. The cells with the "sample" option correspond to patient sample ID in the other column. So, I simply selected all the "sample" cells in one column and move to the other column to get all the patient IDs selected. Now I need to rename them.
I hope this is a bit clearer .
Thanks for the support.
You can still use the same example for what you want to achieve. Would you mind anonymizing your table and uploading a small subset if you dont think the example I provided helps. You can anonymize the table like so: