Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
ch_riadh
Contributor

date

hi
How can i concatenate 2 dates already in the same table. REC_DATE and INV_DATE ?

3 Replies

Re: date

Hi,

try like

REC_DATE &'_'& INV_DATE as NEW_DATE.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

Re: date

Give this fields unique single name like

Load

REC_DATE,

REC_DATE as NewDateField

Load From tableName;


Concatenate


Load

INV_DATE,

INV_DATE as NewDateField

Load From tableName;

ch_riadh
Contributor

Re: date

but the REC_DATE and the INV_DATE are in the same table.

Community Browser