Lesson 3 Lab 1 Answer
Remove duplicate project permits number and keep the revision with the most created unit
Create the ADDRESS field using the following GREL: cells['STREET_NUM'].value + ' ' +cells['STREET_NAME'].value + ' ' +cells['STREET_TYPE'].value + ' ' + cells['STREET_DIRECTION'].value + " Toronto, Canada"
Keep only the field wanted using the removed column option
JSON generated by OpenRefine is available in the course materials. You can copy and paste it in the Undo/Redo > Apply to replay the operation.