Concat () in script ?

[suvechha_b]

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');

[mato32188 · Accepted solution]

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