deduplicate_addresses: Clean up reference address tables
In PHSKC-APDE/apde: Common functions used in APDE's work
View source: R/deduplicate_addresses.R
deduplicate_addresses R Documentation
Clean up reference address tables
Description
deduplicate_addresses removes duplicate addresses in the ref tables and synchronize.
Usage
deduplicate_addresses(conn_hhsaw = NULL, conn_phclaims = NULL)
Arguments
conn_hhsaw
SQL server connection to the HHSAW server, created using odbc package.
conn_phclaims
SQL server connection to the PHClaims server, created using odbc package.
Details
This function brings in all addresses currently in the reference tables
and deduplicates them. Because there is a stage -> final workflow, the stage version
of each table also needs to be deduplicated. Also, the reference tables are currently
synchronized between two different servers. In order to avoid reintroducing
duplicates, both servers must be deduplicated (and synchronized at the same time).
Server and table names are currently hard coded but could be made more generalized if needed.
PHSKC-APDE/apde documentation built on April 14, 2025, 10:46 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
View source: R/deduplicate_addresses.R
| deduplicate_addresses | R Documentation |
Clean up reference address tables
Description
deduplicate_addresses removes duplicate addresses in the ref tables and synchronize.
Usage
deduplicate_addresses(conn_hhsaw = NULL, conn_phclaims = NULL)
Arguments
conn_hhsaw |
SQL server connection to the HHSAW server, created using |
conn_phclaims |
SQL server connection to the PHClaims server, created using |
Details
This function brings in all addresses currently in the reference tables and deduplicates them. Because there is a stage -> final workflow, the stage version of each table also needs to be deduplicated. Also, the reference tables are currently synchronized between two different servers. In order to avoid reintroducing duplicates, both servers must be deduplicated (and synchronized at the same time). Server and table names are currently hard coded but could be made more generalized if needed.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.