topic Re: excel data transformation in QlikView

excel data transformation

vireshkolagimat — Fri, 15 Apr 2016 18:35:14 GMT

Hi Guys,

Could you please help me to bring the attached excel data into Qlikview as it is.

I have multiple sheets which needs be loaded into Qlikview but for now i am looking how to load the attached file into QV.

Thank You

Regards,

Viresh

Re: excel data transformation

Fri, 15 Apr 2016 20:42:12 GMT

Hi Viresh,

Should be simple and plain. Open your Qlik Desktop and CTRL + E (Edit Script) and click on Table Files and bring in the Excel file (One image). Second Image shows Sheet1$ (depicts what sheet one wants to open up in Qlik).

Hope it helps!!!!

Re: excel data transformation

Chanty4u — Sat, 16 Apr 2016 04:38:54 GMT

hi,

Types of Load into QlikView

Re: excel data transformation

Kushal_Chawda — Sat, 16 Apr 2016 05:00:14 GMT

How should be your final data look like?

Re: excel data transformation

jonathandienst — Sat, 16 Apr 2016 08:57:13 GMT

This file is going to be very awkward to load. It combines multi level headers with multiple sub tables on a sheet. It is possible to construct a load script for this spreadsheet, but it will take a while and will probably not be that reliable (minor layout changes will break the load).

It it not possible to get the data reported in a more conventional form? A report like this is usually generated from an underlying source, perhaps you can look at that if you cannot get a simple report.

Re: excel data transformation

vireshkolagimat — Sat, 16 Apr 2016 14:00:48 GMT

yeah that is what even i thought but can we achieve this using macros? I am not that much expert in macros

Re: excel data transformation

vireshkolagimat — Sat, 16 Apr 2016 14:01:46 GMT

It is not a plain excel file. The data is not in the standrd format like rows and columns

Re: excel data transformation

vireshkolagimat — Sat, 16 Apr 2016 14:02:14 GMT

as is in the excel file