topic Question About Generic Loads from a SQL Datasource in QlikView

Question About Generic Loads from a SQL Datasource

Mon, 23 Jan 2012 23:56:44 GMT

Hello,

I'm very confused about how to use generica loads. Here's my situation:

I have a dataset coming from a SQL stored procedure containing 13 fields. I would like to pivot the date field from row to columns. The only way i'm finding to do this in Qlikview is to use a GENERIC load. The problem I am having is that every example I see is oversimplified and not showing how to do this from a SQL datasource.

Can someone show me how?

Thanks!!

Question About Generic Loads from a SQL Datasource

Tue, 24 Jan 2012 06:35:25 GMT

Hi There,

Maybe this example could be helpful:

"Generic Table":

Generic Load * //A generic load, loading all of the fields from your SQL statement.

;

SQL Select //Standard SQL statement extracting all of your fields

Object as GObject,

Atribute as GAtribute,

Value as GValue

from datasource //your data source

;

Hope this helps,

Regards GJ.

Question About Generic Loads from a SQL Datasource

Tue, 24 Jan 2012 18:50:35 GMT

Thank you. I've determined that what I actually need is to use the CROSSTAB functionality in Qlikview. I'm aware that I can also do a GENERIC load, but I think crosstab might be easier for now. I'm struggling a bit with this, so there may be additional questions.