Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

akuttler
New Contributor III

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 Solution

Accepted Solutions
nagaiank
Valued Contributor III

Re: CONCAT ALPHA PRE-FIX STING IN DATA LOAD

You may change the script line to

'DERM02'&PATIENTID as MRN

2 Replies
nagaiank
Valued Contributor III

Re: CONCAT ALPHA PRE-FIX STING IN DATA LOAD

You may change the script line to

'DERM02'&PATIENTID as MRN

akuttler
New Contributor III

Re: CONCAT ALPHA PRE-FIX STING IN DATA LOAD

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