How the data looks like:
How I want it to look like:
Generic LOAD Code, Attribute, Value FROM "https://community.qlik.com/message/1280707" (html, codepage is 1252, embedded labels, table is @1);
You can see here how to combine all generated tables into one:
Regroup tables after Generic Load
So, in your data in may looks like this (PFA)
maybe using a pivot table could be a solution.
May be as in attached file
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.
Retrieving data ...