google-refine

Google Refine Reconciliation: How to auto-replace with result text

Let's say I have cell like this: "Nat. Taiwan Normal Univ., Taipei"

Once I do reconciliation, I get this: Nat. Taiwan Normal Univ., Taipei V V Create new topic Search for match

Then I click on "Search for match" and get a drop down result: "National Taiwan Normal University"

2 questions: - How to I output the result text ("National Taiwan Normal University") in a separate or same column? - Is it possible to output the country, which the result university is in, to a separate column?

Thank you!

Solution

  • The GREL expression cell.recon.match.name will get you the name. Put it in a separate column, so you don't lose the recon object.

    Using "Add column from Freebase" will allow you to add the property /location/location/contained_by with a constraint of "type":"/location/country"