topic * Rows to Columns... Is it Generic Load? * in QlikView

* Rows to Columns... Is it Generic Load? *

IAMDV — Fri, 10 Aug 2012 19:37:44 GMT

Dear All,

I have some data in rows and I need to convert them into columns to display in Table Box (without performing any aggregations). Do I need to use Generic Load or Is there any simple approach to transpose the data? I'm attaching some fictitious data for your reference. It will be great if someone can help me with this request.

Please check the Input Table and we need to convert the script to accomodate Output Table...

Note : There is not Unique/Primay Key within the data.

Many thanks in advance.

Cheers,

www.QlikShare.com

Re: * Rows to Columns... Is it Generic Load? *

swuehl — Fri, 10 Aug 2012 21:33:04 GMT

Hi DV,

not sure if this is the best solution, but I would try something like

INPUT:

LOAD Field1,

Field2,

Field3,

Field4,

Measure

FROM

[.\Rows to Columns.xlsx]

(ooxml, embedded labels, table is [Input Table]);

For i = 1 to FieldValueCount('Measure')

Let a = FieldValue('Measure',$(i));

left join (INPUT) LOAD

'$(a)' as Measure,

'$(a)' as $(a)

AutoGenerate 1;

Next

drop field Measure;

Have a nice weekend,

Stefan

Re: * Rows to Columns... Is it Generic Load? *

Sun, 12 Aug 2012 13:04:47 GMT

Hi DV,

You can look at http://qlikviewnotes.blogspot.co.il/2010/05/use-cases-for-generic-load.html.

Regards,

Yigal.

topic *** Rows to Columns... Is it Generic Load? *** in QlikView

*** Rows to Columns... Is it Generic Load? ***

Re: *** Rows to Columns... Is it Generic Load? ***

Re: *** Rows to Columns... Is it Generic Load? ***

topic * Rows to Columns... Is it Generic Load? * in QlikView

* Rows to Columns... Is it Generic Load? *

Re: * Rows to Columns... Is it Generic Load? *

Re: * Rows to Columns... Is it Generic Load? *