Fast way to replace selected entries with a new valueA user selects some rows and a column and wants to replace the selected entries with a new values via the GUI.
names default to here(1);
colname = "column with values between 1 and 10";
dt = new table("test", add rows(5000000), new column ("c",Character, set each Value(Char(random integer(10)))));
dt << Select Where( :c == "7" ) << select columns (1);
newname = "column with values between 1 and 10, 7=X";
newvalue="X";
:c << set name( newname);
The score is based on time. Every click, every keystroke, every double click and every calculation counts in fractions of a second.
Data Blending and CleanupRe: Fast way to replace selected entries with a new valueCopy & Paste
Re: Fast way to replace selected entries with a new valuelinked Subset: type & Fill to end
It takes forever—better make sure you’ve got a full pot of coffee ready!
Re: Fast way to replace selected entries with a new valueName Selection in Column:
It's accessible right via the column header - sooo cool!
I am sure there is a hidden trick to pick THE selected column as the target column - but I did not find it yet ...
Re: Fast way to replace selected entries with a new valueName Selection in Column - with an auxiliary column:
Re: Fast way to replace selected entries with a new valueWhy not Recode?
It works fine for simple replacements. However, in general, the selected rows won't correspond to a specific value in the target column.
So, the demo case is not ideal. Sorry.
Re: Fast way to replace selected entries with a new valueAnd how to select rows? -> take care there are no variable inside the search expression !
