Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #64: Catch Me If You Can

JoeM
Alteryx Community Team
Alteryx Community Team

The solution to last week's challenge is HERE!

 

You have an input data that has some unknown number of fields and records as a data stream from a file that changes often. You also have a specified list of fields that you want, that also changes often. After each run of this workflow, the data will change. Hence the name of this challenge. Every time you run the workflow, the data inside the inputs will change - making it a little challenging to configure.

 

Hint: You will be looking at lots of Unknown fields - think dynamically!

 

 

NicoleJohnson
14 - Magnetar
14 - Magnetar

Caught ya! 🙂 This was a really fun one!

 

Spoiler
WeeklyChallenge64.JPG

 

AdamR
Alteryx
Alteryx

Fun!  I wonder how many different ways people will find to solve this one.

 

Spoiler
My solution avoids transposing the source data.  But does need the CReW macro pack installed to run.

challenge_64.png
Adam Riley
Principal Software Engineer
Tech Lead Core Engines, Alteryx
patrick_digan
16 - Nebula
16 - Nebula

 

Spoiler
I used a formula tool to setup the column name. I added some asterisks at the beginning of each field name so that I could tell at the end which fields were selected. 
I used a dynamic rename to change the column headings. The dynamic select chose only the field names with the asterisks. The dynamic rename then deleted the asterisks so i had my final output.

Capture.PNG

 

MarqueeCrew
19 - Altair
19 - Altair

@JoeM,

 

I think that I caught you.  I checked my solution against @patrick_digan & @AdamR.  I am very much like Digan and very little like Adam.  Adam, I think that you'll agree that the Crew macros path is a little bit much.  

 

Spoiler
Capture.PNG

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
AdamR
Alteryx
Alteryx

@MarqueeCrew I like to be different 🙂

Adam Riley
Principal Software Engineer
Tech Lead Core Engines, Alteryx
MarqueeCrew
19 - Altair
19 - Altair

@AdamR,

 

You're my favorite and you know it!

 

See you soon!

m

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
alex
11 - Bolide
Spoiler
Week64.JPG
Garrett
11 - Bolide

Dynamic indeed.

Spoiler
dynamic.PNG
toddhowl
7 - Meteor

 

Spoiler
Spoiler64.JPG

 

 

That was fun, thanks!