Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

priyarane
Contributor III

Column Concat

Hi Experts,

How to get concat 2 columns as below in scripts like below.


RefCode,Reportinig_Date

10,         10/11/2013

11,          11/11/2013

20,          12/12/2013

I want out put like below,

Look_Column(New column : RefCode+Reportinig_Date)

1010112013

1111112013

2012122013

1 Solution

Accepted Solutions

Re: Column Concat

Hi,

Try like

RefCode&Date(Reporting_Date,'DDMMYYYY') AS New_column

Regards

Regards,
Prashant Sangle
4 Replies

Re: Column Concat

Hi,

Try like

RefCode&Date(Reporting_Date,'DDMMYYYY') AS New_column

Regards

Regards,
Prashant Sangle

Re: Column Concat


You can also try with purgeChar()

like

RefCode&PurgeChar(Reporting_Date,'/') AS New_column

Regards

Regards,
Prashant Sangle
awhitfield
Esteemed Contributor

Re: Column Concat

Hi Priya,

try:

RefCode & (replace("Reporting_Date",'/','')) AS RefCode_Reporting_Date

I have attached a simple example.

nishant_jadhav
New Contributor III

Re: Column Concat

Hi Priya,


Please try below code.


RefCode&' '&Reporting_Date as New_Col

use & operator to concatenate.

Thanks,

Nishant

Community Browser