Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sorry, I meant to say, I am trying to load an excel file once a month. The header changes every month.