Is it possible to convert a crosstable into Straight Table

[Anonymous]

How the data looks like:

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

How I want it to look like:

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

[antoniotiman]

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]

Hello, Abhay!

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

Regroup tables after Generic Load

[Sergey_Shuklin]

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

[MarcoWedel]

‌maybe using a pivot table could be a solution.

regards

Marco

[ahaahaaha]

Hi,

May be as in attached file

Regards,

Andrey

[#7]

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