When working in record mode, it is possible to compare all the value within one record and see if those are unique. To do that we will introduce the function forEach() that let turn the record into an array and count unique value.
Showing posts with label countif. Show all posts
Showing posts with label countif. Show all posts
5.12.15
16.2.12
Count how often a character occurs in a cell
Did you know that Refine can count how often an string or character appears in a cell?
To achieve this, I first recommend that you store the count result in a separate column (so you do not write over your initial content). Select your reference column (where you want to do the count per cells) and create a new column based on this column. An other option is to store the result in a custom text facet.
We will use the Grel expression value.split(" ").length().
However if the cells does not contains the value Refine will still return '1'. I found two ways to work around this issue.
To achieve this, I first recommend that you store the count result in a separate column (so you do not write over your initial content). Select your reference column (where you want to do the count per cells) and create a new column based on this column. An other option is to store the result in a custom text facet.
We will use the Grel expression value.split(" ").length().
However if the cells does not contains the value Refine will still return '1'. I found two ways to work around this issue.
8.9.11
countif in google refine with facetCount
12:15 PM
cluster, countif, facetCount, grel
Countif is an expression in Excel that count every time a value appears in a determine zone of your spreadsheet. Google refine support the same function to count every time a value appears in a column.
Subscribe to:
Posts (Atom)