OpenRefine Foundation

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.