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.

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

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
8 - Asteroid

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
7 - Meteor
Spoiler
Solution Attached

balajilolla1_0-1641865890021.png

 

kelvinlaw
8 - Asteroid

Here is my solution for all 3 regions:

Spoiler
kelvinlaw_0-1641872066600.png

 

Qiu
18 - Pollux

looking forward for the next week.

Spoiler
challenge_302.PNG
AkimasaKajitani
15 - Aurora

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
14 - Magnetar

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