how to copy paste values in one column to another in google open refine
I basically prefer calling it open refine,as it is no longer supported by google and is a community driven open source project. However, one serious lack for this browser based software is its usage and knowhow information which is spread all across the internet. Today, I will talk about a common limitation that I had faced time and again when I needed to copy extracted data from column-A to column-B, I used to download it as excel and then copy it to column-B and reupload it as separate project. However, I stumbled upon a solution to this problem. Note- Do use filters(text,numeric,etc) as per your need or facets (duplicate facet) as per your project need on both or any on column. What I did was - 1) I used blank filter in open refine 2) then I used transform option on the destination column,where I wanted values to be copied to 3) I used the following function - [Note the syntax] cells["source_col_name"].value and voila! all the values gets copied to the dest