Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

convert rows into colomns

I have table like

table1  this is field name

d1

d2    this are sub fields

d3

I want to get it like

table d1 d2 d3

implementation done in scripting side not in ui side.

plz help me.

1 Solution

Accepted Solutions
buzzy996
Master II
Master II

crosstable

this table is converted from crosstable format to column format.

View solution in original post

3 Replies
buzzy996
Master II
Master II

crosstable

this table is converted from crosstable format to column format.

stigchel
Partner - Master
Partner - Master

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

Use cases for Generic Load | Qlikview Cookbook

robert_mika
Master III
Master III

Data

Transformation:

To:

Script:

Directory;

CrossTable(A, Data)

LOAD Tab1,

     A,

     B,

     C

FROM

CROSSTA.xlsx

(ooxml, embedded labels, table is Sheet1);