Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I Need to Perform some operation on data based on month level, so create a column “MONTH” using renamed column “DATE” .
LOAD SYMBOL,
SERIES,
OPEN,
HIGH,
LOW,
CLOSE,
LAST,
PREVCLOSE,
TIMESTAMP as Date,
TOTALTRADES,
ISIN,
If(WildMatch(SYMBOL,'AAAAAAA*'), 0, SYMBOL)
FROM
[...........................]
(ooxml, embedded labels);
@shrayas if I understood correctly :
...
Month(floor(TIMESTAMP )) as MonthField,
...
and use MonthField after
@shrayas if I understood correctly :
...
Month(floor(TIMESTAMP )) as MonthField,
...
and use MonthField after
Perfect mate thanks!!