Converts a Column containing codes into a Column that contains a Coding struct.
tx_to_coding(coding_column, system, version = NULL)The Column containing the codes.
The URI of the system the codes belong to.
The version of the code system.
A Column containing a Coding struct.
The Coding struct Column can be used as an input to terminology functions such as
tx_member_of and tx_translate. Please note that inside
sparklyr verbs such as mutate the functions calls need to be preceded with
!!, e.g: !!tx_to_coding(CODE, SNOMED_URI).
Other terminology helpers:
tx_to_ecl_value_set(),
tx_to_loinc_coding(),
tx_to_snomed_coding()
pc <- pathling_connect()
condition_df <- pathling_spark(pc) %>% sparklyr::copy_to(conditions)
# Convert codes to ICD-10 codings.
condition_df %>% sparklyr::mutate(
icdCoding = !!tx_to_coding(CODE, "http://hl7.org/fhir/sid/icd-10"), .keep = 'none'
)
#> # Source: SQL [?? x 1]
#> # Database: spark_connection
#> icdCoding
#> <list>
#> 1 <named list [2]>
#> 2 <named list [2]>
#> 3 <named list [2]>
#> 4 <named list [2]>
#> 5 <named list [2]>
#> 6 <named list [2]>
#> 7 <named list [2]>
#> 8 <named list [2]>
#> 9 <named list [2]>
#> 10 <named list [2]>
#> # ℹ more rows
pathling_disconnect(pc)