1 Reply Latest reply: Jun 7, 2018 3:10 AM by Jaume Criballés Faja RSS

    CONCAT ALPHA PRE-FIX STING IN DATA LOAD

    Ashley Kuttler

      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?