Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
sudhakaran_abha
Contributor

Is it possible to convert a crosstable into Straight Table

How the data looks like:

CodeAttributeValue
A001ColorBlue
A001Grp220
A001Grp3100
A002Grp3200
A002Grp210
A002ColorRed
A003Grp4120

How I want it to look like:

CodeColorGrp2Grp3Grp4
A001Blue20100
A002Red10200
A003120
6 Replies
antoniotiman
Honored Contributor III

Re: Is it possible to convert a crosstable into Straight Table

Hi Abhay,

Generic
LOAD Code,
Attribute,
Value
FROM

"https://community.qlik.com/message/1280707"
(
html, codepage is 1252, embedded labels, table is @1);

Regards,

Antonio

serj_shu
Valued Contributor

Re: Is it possible to convert a crosstable into Straight Table

Hello, Abhay!

You can see here how to combine all generated tables into one:

Regroup tables after Generic Load

serj_shu
Valued Contributor

Re: Is it possible to convert a crosstable into Straight Table

So, in your data in may looks like this (PFA)

Re: Is it possible to convert a crosstable into Straight Table

‌maybe using a pivot table could be a solution.

regards

Marco

ahaahaaha
Honored Contributor

Re: Is it possible to convert a crosstable into Straight Table

Hi,

May be as in attached file

Regards,

Andrey

Not applicable

Re: Is it possible to convert a crosstable into Straight Table

Hi Abhay,

You can use resident load option to get the dimensions :- Color,Group 2,Group 3 Group 4.

The script you can use is

generic load Code,Attribute,Value resident DIM_TABLE;

Replace DIM_TABLE with the table u currently use.

Regards,

Rohan Shetty

Community Browser