Challenge #23: Parsing CPG Data

[RolandSchubert]

My solution, once again using the Arrange tool to organize data.

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[FeedMeData]

Tricky but fun!

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[Sajeel_Kershi]

Not the most elegent solution - but does the job

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[RichoBsJ]

Hi! Here my solution 🙂

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[Thableaus]

Challenge #23, done!

Took some time to think how to design the solution. Once designed, it was pretty fast.

Spoiler

Cheers,

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[Sumanshu_GI]

Nice Challenge !!

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[ponraj]

Here is my solution!

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[sachin02]

My solution:

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[T_Willins]

I really liked this challenge.  Real life Alteryx application!

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[JonathanAllenby]

Here's my solution to challenge 23.

I wanted to get a solution that allows for a variable number of soap brand.
My iterative macro allows up to 100 brands since I didn't want to spend even more time counting the number of brands.

By far the most frustrating challenge I've done so far due to struggles in iteration land.

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.