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

Is it possible to convert a crosstable into Straight Table

Anonymous — Fri, 02 Jun 2017 19:33:26 GMT

How the data looks like:

How I want it to look like:

Code	Color	Grp2	Grp3	Grp4
A001	Blue	20	100
A002	Red	10	200
A003				120

antoniotiman — Fri, 02 Jun 2017 20:42:32 GMT

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

Sergey_Shuklin — Sat, 03 Jun 2017 15:27:34 GMT

Hello, Abhay!

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

Sergey_Shuklin — Sat, 03 Jun 2017 15:39:24 GMT

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

MarcoWedel — Tue, 06 Jun 2017 22:42:59 GMT

‌maybe using a pivot table could be a solution.

regards

Marco

ahaahaaha — Wed, 07 Jun 2017 07:03:21 GMT

Hi,

May be as in attached file

Regards,

Andrey

Wed, 07 Jun 2017 08:48:41 GMT

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