Creating Header Name form 2 excel rows

ciaran_mcgowan — Wed, 15 Oct 2014 11:21:36 GMT

Hi all,

I have an issue where I am loading from an excel Cross Table and the full headers for columns are stored in two cells in the excel file. The excel file looks like this:

F16

Region

Name

Role

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Jan

Feb

Mar

Total

Europe

John

123

Worker

100

120

125

110

115

120

100

110

115

The F16 increments every year so I need to create a column that incorporates the financial year & the month (i.e. F16-Apr, F16-May, etc.)

Any thoughts?

topic Creating Header Name form 2 excel rows in QlikView

Creating Header Name form 2 excel rows