Challenge #221: Avocado Consumption

[grazitti_sapna]

Hi, Here is the solution to the challenge.

[szade1]

First time participation in the challenge!!! Really excited 🙂

Spoiler

My workflow:

It can successfully generate the desired output based on dynamic input.
Output:

 

Thanks,

S.

[Sebenius]

looked for a better way to get the sort order correct but did not find anything clever so last step is sadly manual.

Spoiler

[Ladarthur]

my solution, very funny one, brains ending up like, transpose/crosstab/transpose/crosstab! loved it!

[JohanRanschaert]

Spoiler

My solution in attach 

[Jonathan-Sherman]

Challenge 221 is done!

Spoiler

[MichaD]

I think I created a monster... not very elegant but gets the job done...

Spoiler

[RWvanLeeuwen]

Pretty easy, BUT:

The most difficult part of this workflow - which I have yet to tackle - is to automatically rename fields with a _ suffix to a % suffix. I want to do this because reshaping the data model using transpose/crosstab renames special characters with an underscore after remodelling... I think I could do it using a field info tool, union those parts and use a dynamic rename, but I think my workflow will suffice nontheless.

Spoiler

[WJJW-1]

Spoiler

Not my most elegant, but it works.

[CaminoPinan]

My proposal

Spoiler