6 Replies Latest reply: Nov 21, 2017 1:11 PM by Anand Chouhan RSS

    Create Concat Field

    Ashley Kuttler

      Hello,

       

      In the data load editor...how do I add a new field that concatenates three other existing fields?

      Load script below:

       

      Patient_Ledger_2017:

      LOAD

          ENCID,

          ITEMTYPE,

          "Transaction Date",

           "Transaction Time",

           "Service Date"

          Trans,

          CPT,

          UNITS,

          PracticeName,

          LocationName,

          RenderingPhysician,

          BillingProvider,

          "Encounter Total Charges",

          PATIENTID

      FROM [lib://BACKUP/PTLEDGER_2017.csv]

      (txt, utf8, embedded labels, delimiter is ',', msq);

       

      I want to load an additional field that concatenates "Service Date", RenderingPhysician, and PATIENTID for each row.