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

Origin of Bengali Brahmin surnames along with ill effects and implementation of Koulinya Pratha

-
 - 1000 yeras ago, local bengal king Adisur invited 5 brahmins from kingdom or area of erstwhile kannauj - King Adisur is a big landlord/samanta under pal dynasty towards the end of the pal dynasty (source: khitish bangshabali charitam charita - local lineage history record book of Khitish blood line) - Pal dynasty was budhdhist while Adisur was Hindu - Rard desh, banga desh, gour desh, baredra desh were the area under King/landlord/samanta Adisur - time line mentioned in poem: in same book - Bikramabda (this incident happened before onset of gregorian calendar) so 999 Bikramsambat (year) pusha nakshatra on shukla paksha (day) - 942 BC approx - Reason of calling: Adisur was without male child. In ved there is provision of putreshthi yajna. In that time there were 700 household brahmins in the same region but they were unknown to the Vedic Yajna of Putresthi. These 700 brahmin households are call saptasati brahmins. - notably bengal followed non vedic tradition. Mur...
Read more

How does slope influence runoff

-
Runoff is the precipitation excess or the water leaving a drainage area regarded as rainfall minus loss by evaporation or infiltration.Runoff volume is the total volume of runoff water occuring over a period of time where Q(t) is the discharge at time t and the expression is :- Total runoff is the sum of the overland flow,ground water flow and through flow.The reason why water flow down hill over a sloping land surface is because of the following of the Bernoulli's equation .However,other opinion says the reason is decrease in potential energy rather than Bernoulli's equation .Steep slope will provoke speedy movement of water towards the outlet while gentle slope will result in slow movement allowing evapotranspiration.If the soil is porous then there will be infiltration and downflow in the form of throughflow or it may enter the ground water flow.Surface runoff or infiltration excess overland flow can only occur on the catchment slope if :- a)Rainfall rate is gre...
Read more

How using a dishwasher brought relief to my family and how I use it?

-
 Making the choice I came across several youtube videos on dishwasher initially. I am a tech savvy person and love to automate repeatative tasks and I have a goal to automate most of my household repeatative tasks. So, that we get quality time together and are not dependent on domestic help for heavy lifting. We have children and not a large family where she would receive support in child daily activities from family seniors. As a result, we are very much on our own and have to depend on our own time management and on machines - washing machine, refrigerator, 2 wheelers, amazon scheduled deliveries, dishwasher for our comfort and daily work needs. Deciding on the machine I checked different dishwasher online and zeroed in on Voltas beko 8 place set. It is the smallest and the cheapest machine with the highest review in the online e-commerce space.I also did a market study to see if the dishwasher specific detergents are available offline. It is not available. I also went to a local...
Read more