topic Re: Moving column headers to row values - load script in QlikView

Moving column headers to row values - load script

Thu, 10 Sep 2015 16:38:39 GMT

Hello,

I have an Excel data source that looks like follows:

I need to create a column called 'Year' so that I can use this field as a filter and dimension.

I would like my table to be loaded in as follows:

Without changing the data source, is there a way to achieve this in the load script?

Many thanks

Melissa

Anonymous — Thu, 10 Sep 2015 16:45:16 GMT

When you load table in script editor then in File wizard you will find Crosstable option. Using Crosstable you can bring year into one column.

Anonymous — Thu, 10 Sep 2015 16:49:54 GMT

Please find a samle app attached.

Thu, 10 Sep 2015 22:24:30 GMT

That's brilliant, thanks QlikRajan!