Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Concat () in script ?

Hi All ,

How to concat in qliksense script ?

 

[BORD]:
LOAD
CONCAT("RB_CALENDAR_PERIOD",'.',"RECORD_SOURCE_GM_ID",'.',"CLAIM_NUMBER") AS "KEY",
"RB_CALENDAR_PERIOD" as "Import Month",
"RECORD_SOURCE_GM_ID",
"CLAIM_NUMBER",
"GROSS_CLAIMS_PAID" as "EDW Amount";
SQL SELECT[RB_CALENDAR_PERIOD]
,[RECORD_SOURCE_GM_ID]
,[CLAIM_NUMBER]
,[GROSS_CLAIMS_PAID]
FROM [DWUQV_CLAIM_PAYMENT_TRANSACTION] where [RB_CALENDAR_PERIOD] ='2019-01-01'
and RECORD_SOURCE_GM_ID in ('27');

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Re: Concat () in script ?

Hi Suvechha_b,

try 

[BORD]:
LOAD

RB_CALENDAR_PERIOD &'.'&RECORD_SOURCE_GM_ID&'.'&CLAIM_NUMBER as "KEY",

"RB_CALENDAR_PERIOD" as "Import Month",
"RECORD_SOURCE_GM_ID",
"CLAIM_NUMBER",
"GROSS_CLAIMS_PAID" as "EDW Amount";
SQL SELECT[RB_CALENDAR_PERIOD]
,[RECORD_SOURCE_GM_ID]
,[CLAIM_NUMBER]
,[GROSS_CLAIMS_PAID]
FROM [DWUQV_CLAIM_PAYMENT_TRANSACTION] where [RB_CALENDAR_PERIOD] ='2019-01-01'
and RECORD_SOURCE_GM_ID in ('27');

 

BR

Martin

View solution in original post

1 Reply
Highlighted
Creator III
Creator III

Re: Concat () in script ?

Hi Suvechha_b,

try 

[BORD]:
LOAD

RB_CALENDAR_PERIOD &'.'&RECORD_SOURCE_GM_ID&'.'&CLAIM_NUMBER as "KEY",

"RB_CALENDAR_PERIOD" as "Import Month",
"RECORD_SOURCE_GM_ID",
"CLAIM_NUMBER",
"GROSS_CLAIMS_PAID" as "EDW Amount";
SQL SELECT[RB_CALENDAR_PERIOD]
,[RECORD_SOURCE_GM_ID]
,[CLAIM_NUMBER]
,[GROSS_CLAIMS_PAID]
FROM [DWUQV_CLAIM_PAYMENT_TRANSACTION] where [RB_CALENDAR_PERIOD] ='2019-01-01'
and RECORD_SOURCE_GM_ID in ('27');

 

BR

Martin

View solution in original post