topic Re: How can I transform this excel spreadsheet into a normal table in QlikView? in QlikView

Spreadsheet change

jblomqvist — Wed, 11 Nov 2015 21:51:59 GMT

Hi all,

How can I transform the attached spreadsheet into a 'normal' table in QlikView please?

Re: How can I transform this excel spreadsheet into a normal table in QlikView?

sunny_talwar — Wed, 11 Nov 2015 21:56:11 GMT

Something like this?

Script:

Table:

LOAD StudentName,

Grade

FROM

Spreadsheet.xlsx

(ooxml, embedded labels, table is Sheet1, filters(

Transpose()

));

Re: How can I transform this excel spreadsheet into a normal table in QlikView?

jblomqvist — Wed, 11 Nov 2015 22:20:05 GMT

Hi Sunny,

That is perfect. Where can I read more about the two functions you use in QlikView? I cannot locate them in Help. They are interesting.

Re: How can I transform this excel spreadsheet into a normal table in QlikView?

sunny_talwar — Thu, 12 Nov 2015 17:29:58 GMT

Sorry for a late response. So I am not sure if there is anything about this in help, but I can tell you how I did this and how you can do other manipulation to your data within that place.:

Step1: When you on Edit Script window -> click on Table Files... (as you would usually do to bring in any Excel file)

Step2: Click next (after making any changes like Embedded Labels or Header Size or Tables) NOTE: DO NOT CLICK Finish

Step3: Click on Enable Transformation Step

Step4: Do you data manipulation as desired (I used Rotate tab to transpose your data)

I hope this will help.

Best,

Sunny