Perform some operation on data based on month level, so create a column “MONTH” using renamed column “DATE”.

[shrayas]

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);

[Taoufiq_Zarra · Accepted solution]

@shrayas  if I understood correctly :

...

Month(floor(TIMESTAMP )) as MonthField,

...

and use MonthField after

[shrayas]

Perfect mate thanks!!