CONCAT ALPHA PRE-FIX STING IN DATA LOAD

[akuttler]

Hello,

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 :

LOAD

    Date(Floor("Date of Service")) as "Date",

    PATIENTID as MRN,

    ItemCode AS CPT,

    Provider as RenderingPhysician,

    Quantity AS UNITS,

    PracticeName,

    CPT_CATEGORY

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?

[nagaiank · Accepted solution]

You may change the script line to

'DERM02'&PATIENTID as MRN

[akuttler]

Thanks, I thought I already tried that but it worked.