Challenge #302: International Bank of Awesome Data - Part I

[ChristinaFPE]

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

[Reesetrain2]

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.

 

[balajilolla1]

Spoiler

Solution Attached

[kelvin_law1]

Here is my solution for all 3 regions:

Spoiler

[Qiu]

looking forward for the next week.

Spoiler

[AkimasaKajitani]

My solution. It contains EXTRA CREDIT.

Spoiler

But I think a little strange result regarding EXTRA CREDIT.

Spoiler

Sample Output of Region C :

I think it should be this screen shot bellow essentially.

Fun Challenge!!

[messi007]

Below my solution 🙂

Spoiler

[sgarbev]

Spoiler

[kunderwood]

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]

302