Preview result and real result mismatch

Original author: ocean.ch...@gmail.com (August 13, 2011 17:35:25)

When I parseJson certain columns, the Preview window shows me one result, but when I press OK to apply the column returns a blank result instead.

What steps will reproduce the problem?

1. Apply Expression: forEach(value.parseJson()['keywords'], v, v['text'])

To cell containing: { "status": "OK", "url": "", "language": "english", "keywords": [ { "text": "York en route", "relevance": "0.974363" }, { "text": "Anthony Eden", "relevance": "0.814394" }, { "text": "President Eisenhower", "relevance": "0.700189" }, { "text": "friendship treaty", "relevance": "0.647907" }, { "text": "Prime Minister", "relevance": "0.6367" }, { "text": "large section", "relevance": "0.580594" }, { "text": "Washington", "relevance": "0.442583" }, { "text": "Russia", "relevance": "0.22313" } ] }

What is the expected output? Preview window shows result will be: [ "York en route", "Anthony Eden", "President Eisenhower", "friendship treaty", "Prime Minister", "large section", "Washington", "Russia" ]

What do you see instead? blank cells

What version of Google Refine are you using? 2.1

What operating system and browser are you using? Mac 10.6.8 Safari and Firefox

Is this problem specific to the type of browser you're using or it happens
in all the browsers you tried? In both Safari and Firefox

Original issue: http://code.google.com/p/google-refine/issues/detail?id=434

Reproduce the issue in OpenRefine 2.1 using the supplied parseJson expression and JSON value, then compare the Preview result with the result produced by applying the column transformation. Done means the applied column contains the same keyword list shown in the Preview window rather than blank cells.