Is there a way to use existing facet list to check the values in the cell

18 views
Skip to first unread message

Yogesh

unread,
Aug 3, 2017, 9:56:57 AM8/3/17
to OpenRefine
I have a set with of records which contain state and country. Sometimes, the users enter staten for country or country for state. Is there a way to do check if the cell value exists in a facet list of another column? 

For eg. 
cells[STATENAME].value IN facetsofCountries 
OR
cells[COUNTRYNAME].value IN facetsofState 

Thanks in advance.

Yogesh
Reply all
Reply to author
Forward
0 new messages