Fill down missing values

[qps]

Given two columns like this:

Key  Value
001  null
003  null
001  String for key 001

002  null
005  String for key 005

005  null

How would you complete the table so that any null values are replaced by any values we have for that key in the data set? E.g. Row 1 should have a value of "String for key 001".

[Martin Magdinier]

Hello,

You will need to use the record mode in OpenRefine based on your Key column. When reordering you want to make sure that you also reorder by the column Value and have errors and blank cells at the end of the sort. For details, follow the steps in this tutorials http://googlerefine.blogspot.ca/2012/06/create-records-in-google-refine.html

Then you can fill down using the GREL expression  row.record.cells["Value"].value[0] 
Since you have NULL value in your column, you cannot use the fill down function. You can read more about it here: http://googlerefine.blogspot.ca/2012/03/fill-down-right-and-secure-way.html

Martin

--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.