Challenge #221: Avocado Consumption

[grazitti_sapna]

Hi, Here is the solution to the challenge.

[szade1]

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

スポイラ

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.

スポイラ

[Ladarthure]

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

[JohanRanschaert]

スポイラ

My solution in attach 

[Jonathan-Sherman]

Challenge 221 is done!

スポイラ

[MichaD]

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

スポイラ

[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.

スポイラ

[WJJW-1]

スポイラ

Not my most elegant, but it works.

[CaminoPinan]

My proposal

スポイラ