Closed pete-hulson closed 1 year ago
https://github.com/afsc-assessments/afscdata/blob/b36ad961f895d55187889cf810fc5efcef74feb4/R/queries.R#L753 like for the observer catch data, we need to add a join_key so that we can join the catch data tot he specimen and length freq data, can insert here: dplyr::left_join(dplyr::tbl(db, dplyr::sql("norpac.debriefed_haul_mv")) %>% dplyr::rename_with(tolower) %>% dplyr::select(fmp_subarea, gear_type, join_key)) %>%
https://github.com/afsc-assessments/afscdata/blob/b36ad961f895d55187889cf810fc5efcef74feb4/R/queries.R#L753 like for the observer catch data, we need to add a join_key so that we can join the catch data tot he specimen and length freq data, can insert here: dplyr::left_join(dplyr::tbl(db, dplyr::sql("norpac.debriefed_haul_mv")) %>% dplyr::rename_with(tolower) %>% dplyr::select(fmp_subarea, gear_type, join_key)) %>%