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 destination column.

Comments

Post a Comment

Popular posts from this blog

Distinguish between barotropic & baroclinic conditions of the atmosphere

-
An air mass which is defined as a large body of air whose physical properties especially temperature, moisture & lapse rate are more or less uniform horizontally for hundreds of kilometers.                             barotropic condition of atmosphere is theoretically ideal condition where surfaces of constant pressure are not intersected by isostereic(constant density) surfaces, so that in a vertical cross-section isobars(imaginary lines joining places of equal atmospheric pressure) & isotherms appear parallel i.e,zero baroclinicity.It is a rare phenomenon & is found in case of frontogenesis,separated by baroclinic front zone.          Baroclinic condition of atmosphere is seen in comparatively narrow zones (perhaps 1000Km. in width) of thermal discontinuity also known as fronts in air mass property. They are belts of sharp meteorological gradient recognized as distinct factors in the origin of mid-latitude disturbances. The instability is associated with rising wa
Read more

Airtel DTH: Error B001/Error B003 and Why I left Airtel possibly for Better

-
Image
Why did I decided to Leave?  It has been 2 weeks since I complained about B001 error and Airtel in between replaced 2 set top boxes but problem remained. I have replaced everything as per "diagnosis" of airtel DTH technician but no solution could be reached. Currently, my balance has been deducted from INR200 to INR 10. There are discrepancies with the bills issued against parts replacements conducted during this period. It must be stressed here that I as a customer felt cheated, neglected, harassed by Airtel +Service Partner and I was a 7-8 years+ customer. We never saw that set top box seals were broken in front of our eyes for both the replacements by technicians. My comparison chart for new service provider
Read more

Why do isotherms shift north & south from season to season?

-
An isotherm is an imaginary line drawn on a weather chart or map to join places of equal temperature. Temperature varies from season -as there is high temperature during summer & low temperature during winter with minor changes during transitionary seasons. We know that temperature is proportional to atmospheric pressure & inversely proportional to density.                                                        A.P.=K*D*T                                                           T=A.P*1/D where,A.P.=atmospheric pressure;K=constant;D=density;T=temperature      During the summer season in either of the hemisphere's the sun is vertically overhead of the tropic of cancer/capricorn.The land which has a low specific heat capacity & also being a bad conductor of heat re-radiates the heat to the atmosphere resulting in the spreading of molecules of atmospheric gases due to the heat energy. As molecules spread over a wide region it's pressure on the land becomes l
Read more