Solved: Column Concat - Qlik Community

priyarane · ‎2015-03-10

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 · ‎2015-03-10

Hi,

Try like

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

PrashantSangle · ‎2015-03-10

Hi,

Try like

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

PrashantSangle · ‎2015-03-10

You can also try with purgeChar()

like

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

awhitfield · ‎2015-03-10

Hi Priya,

try:

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

I have attached a simple example.

Anonymous · ‎2015-03-10

Hi Priya,

Please try below code.

RefCode&' '&Reporting_Date as New_Col

use & operator to concatenate.

Thanks,

Nishant

Column Concat

Related Topics