Changing Column Header Names

[#1]

Hello,

I am trying to an excel once a month. The header changes every month.

Here is one table load example.

TAB1:

LOAD REPLACE([Category 6],'Grand Total','Total Hours Booked in Retain') as Category,

     [Scheduled Hrs – Engagement (08/01/2016)],

     [Scheduled Hrs – Engagement (09/01/2016)],

     [Scheduled Hrs – Engagement (10/01/2016)],

     [Scheduled Hrs – Engagement (11/01/2016)],

     [Scheduled Hrs – Engagement (12/01/2016)],

     [Scheduled Hrs – Engagement (01/01/2017)],

FROM

(ooxml, embedded labels, table is [Retain Report], filters(

Remove(Row, RowCnd(Compound,

  RowCnd(CellValue, 1, StrCnd(equal, 'Grand Total', not)),

  RowCnd(CellValue, 1, StrCnd(equal, 'Category 6', not))

))

));

Question:

Is there a way as we load the data to name the column[Scheduled Hrs – Engagement (08/01/2016)] as AUG 2016? What I mean is create the name from the date that is part of the excel column name.

So if the column has (8/01/2016) it will be [AUG 2016], if it is (9/01/2016) it will be [SEP 2016].

The name of the columns keep changing every month so the September column moves to the august column location and the august column will be gone.

Thanks

Munir

[#2]

Sorry, I meant to say, I am trying to load an excel file once a month. The header changes every month.