Question About Generic Loads from a SQL Datasource

[#1]

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!!

[#2]

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.

[#3]

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.