topic Re: Column Concat in QlikView

Column Concat

priyarane — Tue, 10 Mar 2015 09:54:16 GMT

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

PrashantSangle — Tue, 10 Mar 2015 09:57:32 GMT

Hi,

Try like

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

Regards

PrashantSangle — Tue, 10 Mar 2015 10:00:08 GMT

You can also try with purgeChar()

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

Regards

awhitfield — Tue, 10 Mar 2015 10:04:30 GMT

Hi Priya,

try:

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

I have attached a simple example.

Anonymous — Tue, 10 Mar 2015 10:33:12 GMT

Hi Priya,

Please try below code.

RefCode&' '&Reporting_Date as New_Col

use & operator to concatenate.

Thanks,

Nishant