We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #188: Difficult, but not im-parse-able

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found here!

 

This week's Challenge come to us from @T_Willins

 
Your tax group has advised you that the information they need is available only in a .TXT report. To properly import the data into a subsequent system, they need the data filtered and in a specified format.

 

First, match the ID no. from the totals rows to the corresponding detail lines. Then filter to only detail rows with a tax codes of P1 or P9. Format, sort order and field names on the output file must match the given output for the file to load correctly.

 

 

impossible.jpg

OllieClarke
15 - Aurora
15 - Aurora

I'm so thankful for RegEx

Spoiler
Challenge 188.png
NicoleJohnson
ACE Emeritus
ACE Emeritus

I got 99 problems and at least 98 of them are RegEx. 🙂

 

Spoiler
WeeklyChallenge188.JPG

Cheers!

NJ

PhilipMannering
16 - Nebula
16 - Nebula

Copied Ollie,

 

Spoiler
WorkflowWorkflow
patrick_digan
17 - Castor
17 - Castor

I'm on a roll over complicating these last few challenges.

Spoiler
Annotation 2019-11-04 133409.jpg
justindavis
10 - Fireball

Start file contains a few rogue tools, at least when I downloaded it... Was that intended?

 

Spoiler
188_problem.PNG


challenge_188_solution_justindavis.PNG
Blake
12 - Quasar

This was a fun one! 

 

Spoiler
challenge_188_BH.PNG

 

paulfound
11 - Bolide

may need to up my Regex game...

 

Spoiler
PaulFound_0-1572897868935.png

Edited: better image of workflow. 🙂  

hbraunius
8 - Asteroid

My solution attached.

LiD
8 - Asteroid
Spoiler
LiD_0-1572904061369.png