Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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