I am pulling simiar data form several different sources, I a field "patient id' which is not unique across the different sources and I would like to insert an alpha prefix to distinguish the data source:
So if my load scirpt is :
Date(Floor("Date of Service")) as "Date",
PATIENTID as MRN,
ItemCode AS CPT,
Provider as RenderingPhysician,
Quantity AS UNITS,
SQL SELECT *
FROM DataMart.dbo."DERM02Custom Charge Report"
WHERE PATIENTID is numerical.
Can I use concat or some other function to insert "DERM02" in front of each patientid?