Once you have imported your data, it is important to familiarize yourself with OpenRefine’s layout.
There are two settings for the grid view in OpenRefine: rows or records.
The difference between rows and records is that “rows” display your data in individual lines, each numbered separately, while “records” display your data in multi-line groupings depending on the relationships between the data in those lines. For example:
This data has been transformed using “split multi-valued cells” on the author field to separate different authors into their own lines. On the left, the data is displayed as “records,” showing the different lines with the multiple authors grouped together. On the right, the data is displayed as “rows,” showing each of the multiple authors as a separate line.
NOTE: Take caution when permanently renumbering rows or records and be aware of what setting you are viewing your data under.
5/1//2018 - Brinna Michael