confirm_overlap and pull()

[astraetech]

Hi,

I was wondering if I can use dplyr operators in the confirm_overlap and finish them with pull()? Something like:
confirm_overlap(top1000_hist_1_2_1_ret %>% filter(any(p_growth_shock_scaled_sum_msa_yr !=0)) %>% distinct(fhfa_msa_code) %>% pull(), tn_msa_100_hpi_curr_gdp_1_1$tn_msa_fhfa_msa_code)

It works with simple queries for mtcars but for other queries using more complex datasets like the one above confirm_overlap shows this error:
Error in splice():
! The LHS of := must be a string or a symbol
Run rlang::last_error() to see where the error occurred.

I opened the function but quickly got lost. If you could shed any light, it would be great! Thank you!

[Harrison4192]

Hi,

My recommendation for complex queries is simply to perform them outside and save the result to a variable, then put the variable into confirm_overlap. The confirm_overlap function captures the names of the inputs with enexpr and uses them to give names to the output. A complicated pipeline won't be able to be parsed as a name, and will throw an error. I've only manually included a workaround for using the "$" operator on data frames directly inside confirm_overlap.

[astraetech]

Understood, thank you!