Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jblomqvist
Specialist
Specialist

Spreadsheet change

Hi all,

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

1 Solution

Accepted Solutions
sunny_talwar

Something like this?

Capture.PNG

Script:

Table:

LOAD StudentName,

    Grade

FROM

Spreadsheet.xlsx

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

Transpose()

));

View solution in original post

3 Replies
sunny_talwar

Something like this?

Capture.PNG

Script:

Table:

LOAD StudentName,

    Grade

FROM

Spreadsheet.xlsx

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

Transpose()

));

jblomqvist
Specialist
Specialist
Author

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)

Capture.PNG

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

Capture.PNG

Step3: Click on Enable Transformation Step

Capture.PNG

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

Capture.PNG

Capture.PNG

I hope this will help.

Best,

Sunny