community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #151: Meta Parsing

Alteryx
Alteryx

I update my solution with the sort order on the columns automated !

Alteryx
Alteryx

Went down the macro route!

 

Added steps to make sure the columns are ordered correctly.

Alteryx
Alteryx

A great use case for a batch macro!

 

Spoiler
challenge_151.pngchallenge_151_macro.png
Alteryx
Alteryx

The Batch macro approach was my first instinct, but then I got through the more 'standard' route! @MichalM, nice to see yours completed the way I imagined it in the first place (and failed to deliver, sigh!)

 

Spoiler
- It was interesting to see the CrossTab tool reorders both fields and records alphabetically. In order to get the ouputs consistent with the desired outputs, I used the RecordID + Dynamic rename needed on the Data Dictionary input stream and another RecordID tool in the DataSet input stream
GC151.JPG
Spoiler
AWC_151.PNG
Alteryx Certified Partner
Alteryx Certified Partner

This is a great challenge for that data prep type thinking; and solutions can be a lot simpler than people think.

 

Fortunately, I've been presented with this problem a few times over the last 6 months so I found my way through it relatively simply!

 

Spoiler
2019-02-11_15-28-18.png

My first challenge post. Admittedly, I begged, borrowed and stole from anywhere I could find - but learned a lot!

Capture.PNG

Alteryx Partner

Here is my solution. Using macro.

 

Spoiler
Solution1.png
Solution2.png
Meteor

Was doing the cross tab step wrong at first, but got it in the end.

 

Spoiler
Capture.PNG
Alteryx Partner

Great challenge. Curious about the other solutions.