Geek asks and answers

Cell.cross () returns an error in Google Refine projects

I'm trying to create a new column based on my main Date column for a project that pulls timeline events from another Google Refine project:

cell.cross ("Timeline Clean5", "TimelineDate"). cells ["TimelineEvent"]. value [0]

Dates are in the same format in both Google Refine projects. But it does not fill the cells, and I get this error:

Error: cannot get field from null

This - cell.cross ("Timeline Clean5", "TimelineDate") - returns [] for rows where there should be a match.

And this is cell.cross ("Timeline Clean5", "TimelineDate"). Cells ["TimelineEvent"] - returns null for these rows.

I copied the syntax directly from the GREL help files: http://code.google.com/p/google-refine/wiki/GRELOtherFunctions . Can anyone suggest that I can ignore?

Thank.

+3
source share
1 answer

Without access to your projects, it will be difficult to answer this, but the first thing I propose is that you clip your expression to find out exactly where the zero occurs.

WITH

cell.cross("Clean5 Timeline", "TimelineDate")

returns an empty array ([]), nothing based on this result will work.

, : 1) ; 2) ; 3) ( Refine , ) 4) cross(), Refine 2.5.

Refine , , ​​ . OpenRefine 2.6.

+3

More articles:


All Articles