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 #402: Parsing Equipment Tags

binuacs
20 - Arcturus

 

Spoiler
image.png

 

 

tsoysal
5 - Atom
Spoiler
Capture.PNG

dwstada
10 - Fireball

my solution :)

 

Spoiler
c402.PNG

Flo_P
8 - Asteroid
Spoiler
I liked this one and I like my solution
image.png
sergejs_kutkovics
8 - Asteroid

It's a REGEX !!

Spoiler
Capture.PNG

Probably, my regex expression is overcomplicated. )

Chris-Nienart
7 - Meteor

Here are some hints for creating the new tags

1. PARSE the original tag for the tag ending
2. Convert CHARacters to INTegers
3. Determine rows to GENERATE based on range
4. Use some FORMULAs to create a new tag ending

 

I think it is important to keep the logic simple and easy to follow. If there was a follow up task, like permitting non-consecutive letters (i.e. C123A/B/D), you would need to make small modifications and wouldn't want to come up with an entirely new solution.

 

Spoiler
spoiler-402.png
AkimasaKajitani
17 - Castor
17 - Castor

My solution for cloud!!

 

Designer Cloud and Trifacta don't have Generate Row tool. So I use other tool instead.

Designer Experience

Spoiler
スクリーンショット 2023-11-28 220054.png

Text Input tool's data is as follows.
スクリーンショット 2023-11-28 221230.png


This screenshot is Designer Desktop version.

スクリーンショット 2023-11-28 222137.png

Trifacta Classic 

Spoiler
スクリーンショット 2023-11-28 220043.png

スクリーンショット 2023-11-28 220049.png

 

AYXAcademy
Alteryx
Alteryx

Hi @Watermark , the problem lies with the Null values generated after your Text to Columns tool. If you add a Data Cleansing tool and adjust your formula a little, you can get rid of this error.  😉

 

I'm attaching the workflow if you want to take a look.

phottovy
13 - Pulsar
13 - Pulsar

I've always wondered how to create the alphabet using the generate rows tool and now I know thanks to this post: 

Generate Rows: increment letters like numbers 

 

Generate Alphabet.png

 

My solution:

Spoiler
402.png
Watermark
12 - Quasar
12 - Quasar

Yep yep yep, the second I read your reply mention nulls I went and tweaked it. Then looked at your flow to see how you handled it, and they were identical. Thanks for the shout!