sum function in GREL in OpenRefine
In OpenRefine, I'm trying to increase the value of every number in a column by 1.
The GREL expression sum([value],1) gives me Error: sum expects an array of numbers.
I guess I don't know how to produce an array of numbers. When I use a different function on the same column, such as tan([value]), I get the result I want.
Solution
I think you misunderstood the use of sum(). If you just want to add 1 to each cell, just use value + 1.
Make sure, however, that your column contains numbers (in green) and not strings (in black). If in doubt, use toNumber(value) + 1 instead.
The sum() function allows to add all the numbers contained in an array, for instance sum([1,2,3,4]) = 10, but you have no array if each cell of your column contains a unique number.
- In OpenRefine, how to import multiple selected columns at once from another project using GREL or Python
- Openrefine cannot fetch html code inside accordion
- OPenRefine GREL removing words if present in another column
- Where does openrefine store projects?
- Simple OpenRefine IF to create a new column
- OpenRefine: How to delete content of cells if it matches specific string pattern?
- OpenRefine: How to create a unique row for each input in a column ( dilneated by comma)
- Openrefine - Extract the instance of
- openrefine - Sorting column contents within a record?
- How to delete least filled duplicate rows?
- Extract XML attribute value based on element value
- Extracting skos:closeMatch from RDF/XML using GREL in OpenRefine
- Split multi-valued cells paired with other multi-valued cells in other rows
- Open Refine: Exporting nested XML with templating
- OpenRefine: after reconciliation, I want to retrieve the title of Wikidata items in other languages
- regex: get everything that doesn't fit in hooks
- Cannot add python Requests module to OpenRefine
- Transposing to records with different lengths
- Fetching a redirect's target URL in OpenRefine
- Is there a function in GREL to remove many columns at once based on their headers in OpenRefine?
- fetching wikidata labels in other languages from reconciled column
- OpenRefine + RDF: handling repeated occurrences
- Use POST method with URL and Google Refine/ OpenRefine
- Open Refine / Google Refine - Remove blank cells in a column
- openrefine/googlerefine - reconcile two datasets
- Underscore and dash in column names after JSON import
- OpenRefine: Inverting a regular expression
- OpenRefine sample extension not building
- Does OpenRefine support Python3?
- OpenRefine: swapping order strings within a column of values