Transposing one field in a table

andreminnaar — Wed, 07 Dec 2022 09:41:38 GMT

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?

Re: Transposing one field in a table

marcus_sommer — Wed, 07 Dec 2022 11:19:26 GMT

- Marcus