topic how to load spreadsheet with merged headers in QlikView

how to load spreadsheet with merged headers

twills12 — Wed, 25 Nov 2020 16:16:04 GMT

Struggling with the proper way to code my load statement. I have an excel file with merged headers that makes it difficult to tell the time periods.

Is there a way to associate the years correctly with each of the phase/quarters?

Re: how to load spreadsheet with merged headers

vishsaggi — Tue, 05 Sep 2017 18:56:54 GMT

What is your expected output?

Re: how to load spreadsheet with merged headers

twills12 — Tue, 05 Sep 2017 19:12:04 GMT

Maybe something like this?

Re: how to load spreadsheet with merged headers

vishsaggi — Tue, 05 Sep 2017 19:26:01 GMT

How is your rawdata like? In your first excel sheet you sent us some pivoted data. In your second excel sheet you have all the data properly adjusted. So can you clarify like what is your original data looks like and what it should be converted to?

Re: how to load spreadsheet with merged headers

twills12 — Tue, 05 Sep 2017 19:33:23 GMT

The first file is a subset of the source data. That is how they have it for me to load.

The second file is what would be easiest to have in my application to build their charts upon.

So I guess the question is, can the load be coded to take the first file and have the resulting table look like the second file?

Re: how to load spreadsheet with merged headers

vishsaggi — Tue, 05 Sep 2017 19:56:08 GMT

Cross Load should do. You should check here?

The Crosstable Load

Re: how to load spreadsheet with merged headers

vishsaggi — Tue, 05 Sep 2017 20:04:51 GMT

Not a straight forward option you have to manipulate some transformations in it.

Re: how to load spreadsheet with merged headers

twills12 — Tue, 05 Sep 2017 20:07:21 GMT

Yes the use of the merged headers for the years is making it a little difficult, otherwise it would be easy enough to do.