How to combine three fields in to one field from same table

[rkpatelqlikview]

Hi,

Hope you are doing great!

Can any one please explain how to combine multiple fields into one field?

Please find the attached excel example data.

from timestamp field i need only date and need to combine in to one field.

Thanks for advance.

[pradosh_thakur]

for this what need to be the output

11

JJ

2017-10-24 17:43:31

2017-10-25 19:26:37

in rowno 11 there are multiple dates which dates need to be there ? or you want both the dates ?

[vangurideepu]

Hi Kumar,

try like this, Using concatenate symbol

we can combine the fields

CapturedDate1&'|'&CapturedDate2&'|'&CampturedDate3 as FinalDate,

Regards

Pradeep

[kenphamvn]

Hi

Please give expected result for this data

Regards

An Pham

[rkpatelqlikview]

Thanks for your response.

That fields all are Timestamps, from that i need only Date and need to combine the three fields in too one fields.

Like this,

23.10.2017

24.10.2017

25.10.2017

[rkpatelqlikview]

Thanks Pradeep,

Can you please find below scripts.It's showing wrong.

please advice.

TRIP:

LOAD

Date1 &'|'& Date2 &'|'& Date3  as finalDate,

     [Carrier Name],

     [Carrier Code],

     DATE(DayStart([Stage1Captured Time], 'DD.MM.YYYY')) as Date1,

     DATE(DayStart([Stage2Captured Time], 'DD.MM.YYYY')) as Date2,

     DATE(DayStart([Stage3Captured Time], 'DD.MM.YYYY')) as Date3,

FROM

(...

(ooxml, embedded labels, table is [Trip Report]); 

[rkpatelqlikview]

Thanks for your response Pham,

Its should be only one date. Excludes time.

FinalDate

23.10.2017

[shanky1907]

Try preceding load:

TRIP:

LOAD

Date1 &'|'& Date2 &'|'& Date3  as finalDate,

     [Carrier Name],

     [Carrier Code],

     DATE(DayStart([Stage1Captured Time], 'DD.MM.YYYY')) as Date1,

     DATE(DayStart([Stage2Captured Time], 'DD.MM.YYYY')) as Date2,

     DATE(DayStart([Stage3Captured Time], 'DD.MM.YYYY')) as Date3;

LOAD

       [Carrier Name],

     [Carrier Code],

     Stage1Captured Time,

     Stage2Captured Time,

     Stage3Captured Time

FROM

(...

(ooxml, embedded labels, table is [Trip Report]);

• How to combine three fields in to one field from same table

[rkpatelqlikview]

Hi Shashank,

Its not working.

LOAD *,

Date1 &'|'& Date2 &'|'& Date3  as finalDate;

LOAD *,

     DATE(DayStart([Stage1Captured Time], 'DD.MM.YYYY')) as Date1,

     DATE(DayStart([Stage2Captured Time], 'DD.MM.YYYY')) as Date2,

     DATE(DayStart([Stage3Captured Time], 'DD.MM.YYYY')) as Date3;

LOAD

       [Carrier Name],

     [Carrier Code],

     Stage1Captured Time,

     Stage2Captured Time,

     Stage3Captured Time

FROM

(...

(ooxml, embedded labels, table is [Trip Report]);

[shanky1907]

What is the error?