topic Re: convert rows into colomns in QlikView

convert rows into colomns

Wed, 25 Mar 2015 14:08:08 GMT

I have table like

table1 this is field name

d2 this are sub fields

I want to get it like

table d1 d2 d3

implementation done in scripting side not in ui side.

plz help me.

buzzy996 — Wed, 25 Mar 2015 15:49:46 GMT

crosstable

this table is converted from crosstable format to column format.

stigchel — Wed, 25 Mar 2015 16:03:20 GMT

That sounds like you need a generic load, see below link for an explanation:

robert_mika — Wed, 25 Mar 2015 16:12:07 GMT

Data

Transformation:

To:

Script:

Directory;

CrossTable(A, Data)

LOAD Tab1,

FROM

CROSSTA.xlsx

(ooxml, embedded labels, table is Sheet1);