Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
How can I transform the attached spreadsheet into a 'normal' table in QlikView please?
Something like this?
Script:
Table:
LOAD StudentName,
Grade
FROM
Spreadsheet.xlsx
(ooxml, embedded labels, table is Sheet1, filters(
Transpose()
));
Something like this?
Script:
Table:
LOAD StudentName,
Grade
FROM
Spreadsheet.xlsx
(ooxml, embedded labels, table is Sheet1, filters(
Transpose()
));
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)
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