topic Re: Load matrix from Excel in Water Cooler

Load matrix from Excel

Tue, 15 Apr 2014 12:45:30 GMT

Hi everybody! I need please load this matrix from Excel. Red fields are columns that I need to load. It is posible with Qlikview?

Thank you!

Re: Load matrix from Excel

sujeetsingh — Tue, 15 Apr 2014 13:50:09 GMT

See this

Transposing data matrix in Excel to table in QlikView

Re: Load matrix from Excel

Tue, 15 Apr 2014 14:00:23 GMT

Yes, I had seen this. But it is different I have in ths first column, many fields. The structure is different.

Re: Load matrix from Excel

richard_pearce6 — Tue, 15 Apr 2014 14:16:26 GMT

Hi,

You have a number of challenges here which may be very difficult to overcome with script without first formatting the source data.

For instance your field names are duplicated unless you combine them with the line above.

Personally I would either change the data extract at source (presuming you have a database) or failing that I would create a second sheet and by using excel lookup functions create a more readable source file.

Richard