Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
If I have the following data
LOAD * INLINE [
Animal, Food
Worm, Apple
Worm, Peach
Worm, Banana
Frog, Crickets
Frog, Fruit Flies
];
but I want the data in the following format
LOAD * INLINE [
Animal, Food1, Food2, Food3
Worm, Apple, Peach, Banana
Frog , Crickets, Fruit Flies
];
is there a way to do something like this?
Take a look here: The Generic Load - Qlik Community - 1473470
- Marcus