topic date in QlikView

date

ch_riadh — Mon, 20 Oct 2014 09:37:06 GMT

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

PrashantSangle — Mon, 20 Oct 2014 09:40:43 GMT

Hi,

try like

REC_DATE &'_'& INV_DATE as NEW_DATE.

Regards

its_anandrjs — Mon, 20 Oct 2014 09:42:03 GMT

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 — Mon, 20 Oct 2014 10:08:19 GMT

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