search

afsc-assessments / afscdata

An R package for data extraction of AFSC survey and fishery data
https://afsc-assessments.github.io/afscdata/
Other
2 stars 0 forks source link

add join_key #39

Closed pete-hulson closed 1 year ago

pete-hulson commented 1 year ago

https://github.com/afsc-assessments/afscdata/blob/b36ad961f895d55187889cf810fc5efcef74feb4/R/queries.R#L769 like for the earlier line, need to add: dplyr::left_join(dplyr::tbl(db, dplyr::sql("norpac.debriefed_haul_mv")) %>% dplyr::rename_with(tolower) %>% dplyr::select(fmp_subarea, gear_type, join_key)) %>%