Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jblomqvist
Contributor II

Spreadsheet change

Hi all,

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

1 Solution

Accepted Solutions

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

Something like this?

Capture.PNG

Script:

Table:

LOAD StudentName,

    Grade

FROM

Spreadsheet.xlsx

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

Transpose()

));

3 Replies

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

Something like this?

Capture.PNG

Script:

Table:

LOAD StudentName,

    Grade

FROM

Spreadsheet.xlsx

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

Transpose()

));

jblomqvist
Contributor II

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

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?

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

Community Browser