Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #302: International Bank of Awesome Data - Part I

ChristinaFPE
7 - Meteor

I probably used more tools than I actually needed but it was a fun challenge!

Reesetrain2
9 - Comet

All,

 

Spoiler
I used:
6 Text to Column tools!
3 Formula Tools

-I used the Record ID tool and the used the filter which was different than others so far.
-My biggest struggle was that I was able to parse the data evenly or I could have used the dynamic rename to relabel the data vice using it only as a guide
-I did get creative with the formula tool in getting the transaction day of the month.

To Be clear: I Try to use Workflows with as little as possible custom code.
Capture.PNG

 

balajilolla1
8 - Asteroid
Spoiler
Solution Attached

balajilolla1_0-1641865890021.png

 

kelvin_law1
9 - Comet

Here is my solution for all 3 regions:

Spoiler
kelvinlaw_0-1641872066600.png

 

Qiu
20 - Arcturus
20 - Arcturus

looking forward for the next week.

Spoiler
challenge_302.PNG
AkimasaKajitani
17 - Castor
17 - Castor

My solution. It contains EXTRA CREDIT.

 

Spoiler

AkimasaKajitani_1-1641905065255.png

 

But I think a little strange result regarding EXTRA CREDIT.

Spoiler

Sample Output of Region C :

AkimasaKajitani_2-1641905223049.png


I think it should be this screen shot bellow essentially.

AkimasaKajitani_3-1641905323660.png

 

Fun Challenge!!

messi007
15 - Aurora
15 - Aurora

Below my solution 🙂

 

Spoiler
messi007_0-1641906981151.png

 

sgarbev
7 - Meteor
Spoiler
sgarbev_0-1641911837403.png

 

kunderwood
8 - Asteroid

This challenge gave me a refresher on Regex and tested my preparation skills! I needed to look at another persons solution to get past the Regex right for Bank B.

rmassambane
10 - Fireball

302