Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 ?
Hi Kumar,
try like this, Using concatenate symbol
we can combine the fields
CapturedDate1&'|'&CapturedDate2&'|'&CampturedDate3 as FinalDate,
Regards
Pradeep
Hi
Please give expected result for this data
Regards
An Pham
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
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]);
Thanks for your response Pham,
Its should be only one date. Excludes time.
FinalDate
23.10.2017
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]);
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]);
What is the error?