Changing Column Header Names

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Changing Column Header Names

Tue, 09 Aug 2016 12:44:05 GMT

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

topic Re: Changing Column Header Names in QlikView

Changing Column Header Names

Re: Changing Column Header Names