Spreadsheet change

[jblomqvist]

Hi all,

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

[sunny_talwar · Accepted solution]

Something like this?

Script:

Table:

LOAD StudentName,

    Grade

FROM

Spreadsheet.xlsx

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

Transpose()

));

[jblomqvist]

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.

[sunny_talwar]

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