Extra rows returned when joining assets on facilities_attributes

Auckland-Council-CC-Insights-Team / porowhitahauwha

Interact With Data About Facilities And Partners Within The Connected Communities Portfolio

https://auckland-council-cc-insights-team.github.io/porowhitahauwha/

Other

1 stars 0 forks source link

Extra rows returned when joining assets on facilities_attributes #5

Open lddurbinAC opened 1 year ago

lddurbinAC commented 1 year ago

https://github.com/Auckland-Council-CC-Insights-Team/porowhitahauwha/blob/35962ea71256ce86f26ca2089abf76128ee93b7c/R/read.R#L16-L21

When joining on facilities_attributes, filter so we're only joining on facility_type='Asset'. Kudos to @jfaatui for spotting this when joining using SQL!