Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Specialist
Specialist

Spreadsheet change

Hi all,

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

1 Solution

Accepted Solutions

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

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

Specialist
Specialist

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.

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