Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vidyasagar159
Creator II
Creator II

Merging the last column rows to first columns

Hello Everyone,

Can someone please help me in achieving the format table view? 

Actual Table:

NamecolorCategory
AppleRedFruit
ApplegreenFruit
GrapewhiteFruit
GrapeblackFruit
Onionwhiteveggi
OnionRedveggi
PepperRedVeggi
Peppergreenveggi

 

Expected / Result:

Namecolor
Fruit 
AppleRed
Applegreen
Grapewhite
Grapeblack
Veggi 
Onionwhite
OnionRed
PepperRed
Peppergreen
Labels (2)
1 Reply
Vegar
MVP
MVP

 

Try this

For each _cat in FieldValueList ('Category') 

Load '$(_cat)' as Name, 

NULL () as color 

Autogenerate (1);

CONCATENATE LOAD Name, color from Source

WHERE Category = '$(_cat)';

Next

Plees ekskuse my Swenglish and or Norweglish spelling misstakes