Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
T1:
Load
Date(Replace(Date,'o','0'),'DD-MMM-YYYY') as DATE,
Value
FROM [lib://DB/Date Task.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Sheet1);
Concatenate
LOAD
Date2 as DATE,
Value2 as Value
FROM [lib://DB/Date Task.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Sheet1);
Concatenate
LOAD
Date(Date3,'DD-MMM-YYYY') as DATE,
Value3 as Value
FROM [lib://DB/Date Task.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Sheet1);
Concatenate
LOAD
Date(Date#(Date1,'DD-MM-YYYY hh:mm:ss TT' ),'DD-MMM-YYYY') as DATE,
Value1 as Value
FROM [lib://DB/Date Task.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Sheet1);
T2:
Load
DATE,
Sum(Value) as VALUE
Resident T1
Group By DATE;
Drop Table T1;
Got the Answers hope it might be usefull
@sutharsan Which Date Column are we talking about here? Because I see date column from multiple table.
However your can try Date('Date','DD-MMM-YYYY')
Else
Date(Date#('Date','DD-MMM-YYYY'),'DD-MMM-YYYY')
Hi man,
we need to change all the date format to DD-MMM-YYYY and display it as one table and sum the values .
Tried these but it showing null values
@ Can you please provide the sample data set?
Here You Go
T1:
Load
Date(Replace(Date,'o','0'),'DD-MMM-YYYY') as DATE,
Value
FROM [lib://DB/Date Task.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Sheet1);
Concatenate
LOAD
Date2 as DATE,
Value2 as Value
FROM [lib://DB/Date Task.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Sheet1);
Concatenate
LOAD
Date(Date3,'DD-MMM-YYYY') as DATE,
Value3 as Value
FROM [lib://DB/Date Task.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Sheet1);
Concatenate
LOAD
Date(Date#(Date1,'DD-MM-YYYY hh:mm:ss TT' ),'DD-MMM-YYYY') as DATE,
Value1 as Value
FROM [lib://DB/Date Task.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Sheet1);
T2:
Load
DATE,
Sum(Value) as VALUE
Resident T1
Group By DATE;
Drop Table T1;
Got the Answers hope it might be usefull