Export linkage table to SQL
At the moment, we build a temporary linkage table as an in-memory data frame and use it to clean the LIMS data. It's looking though like there is a use case for somebody coming to us with any patient/sample/kit ID and needing it routed to a valid patient ID. We should export this as a new SQL table:
linkage_table
entity_id patient_id
SMG0123456 ABCDE-0001
0123457 ABCDE-0001
123458 ABCDE-0001
123458-R ABCDE-0001
CCP0001 ABCDE-0001
CCPI002 ABCDE-0001
CCPNBATCH003 ABCDE-0001
CVRI0001 ABCDE-0001
RRV03-0001 14152-0001
Edited by mwham