Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

CONCAT ALPHA PRE-FIX STING IN DATA LOAD

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?

1 Reply
Highlighted
Creator III
Creator III

Hi,

Try this:

LOAD

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

    'DERM02' & PATIENTID as MRN,

    ItemCode AS CPT,

    Provider as RenderingPhysician,

    Quantity AS UNITS,

    PracticeName,

    CPT_CATEGORY

SQL SELECT *

FROM DataMart.dbo."DERM02Custom Charge Report"