Challenge #235: Spell It Out For Me - Part 2

A solution to last week's challenge can be found here. Source: https://www.forbes.com/sites/jimwang/2020/02/17/how-to-write-a-personal-check/#558fbbd56818

This week's challenge picks up where we left-off last week. As it turns out, the values we formatted last week were prices on a contract. It is common in many legal documents to write out the values displayed as an additional redundancy to ensure everyone is on the same page and there are no typos. Maybe we should do the same...

Convert the values in the table into written form. (e.g. 9612001.00 > nine million six hundred twelve thousand one dollars and no cents)

challenge_235_start_file.yxzp

challenge_235_solution.yxzp

Join

Preparation

Intermediate

Data Preparation

Core

Transform

Accepted answers

All comments

Aaron_Harter

What a challenge! Looking forward to seeing more efficient solutions.

Spoiler

challenge_235_AB Data_Aaron.yxzp

atcodedog05

Seems like i am missing out somewhere

Spoiler

I ran into a issue for values between 10-19 teens. But fixed it.

atcodedog05

This sure did take me a while writing the formulas. But finally i am done

Spoiler

Cheers and Happy analyzing : )

challenge_235_atcodedog05_solution.yxzp

RolandSchubert

Interesting challenge. Did most of the work using formulas.

Spoiler

challenge_235_solution_rsc.yxmd

paulfound

Spoiler

Feel it could be done with less tools and something to do with the summary tool, but couldn't picture it.

challenge_235_pf.yxmd

AkimasaKajitani

My solution.

Spoiler

I'm not used to the rules of English numbers.

challenge_235_start_file_AK.yxzp

IAJ1966

Tricky and rather fiddly, but got there in the end!

Not sure if this was the most efficient approach though!??

challenge_235_solution_IAJ.yxzp

phottovy

This one takes some creativity:

Spoiler

challenge_235_ph_solution.yxzp

OllieClarke

I made things a little trickier for myself by making it more like speech, (adding ands and whatnot). Good challenge, I'm sure there'll be more elegant solutions than mine 🙂

Challenge 235 Out.PNG

Spoiler

Challenge_235_OC_Solution.yxzp

LHolmes

I took a very non-dynamic, although extremely simple, route that will work for amounts less than one billion.

Spoiler

Two tools.
235 - Solution.PNG

challenge_235_solution_lmh.yxzp

hlmess

I made this as dynamic as I could think to with the only assumption being that we won't go below the cent level.

It's needlessly complicated and there are many potential improvements but it's very flexible as is with nothing really hardcoded.

Spoiler

challenge_235_hayden.yxmd

Tony_Castillo

Spoiler

There's commonality between field logic:
1 & 4 & 7
2 & 5 & 8
3 & 6
Seems there is a solution with Dynamic Replace somewhere but don't have the time for a second solution. The attached solves the challenge. Looking forward to seeing more efficient ways to solve from the community.

challenge_235_solution_TC.yxmd

ggruccio

Spoiler

I created the logic for cents, then dollars and hundreds of dollars, then repeated for thousands and millions.

challenge_235_gg_finish.yxzp

TonyA

Here's my solutions. Not hard to get an answer, but it's pretty tedious. I sacrificed some efficiency in an effort to make this easier to follow. Next step would be to adjust "dollars" and "cents" to account for "one dollar" or "one cent." to do that I would probably test the original values from the first exercise instead of mucking around with the number broken into columns.

Spoiler

challenge_235_TonyA.yxmd

ngaskill1

After having gone through the exercise, I probably could reduce the number of formulas but this works with just a few tools.

Spoiler

challenge_235_solution.yxmd

Nicholas_Norton

Spoiler

After a while, I gave up and used @RolandSchubert's solution as a reference. I'll have to try again after a couple days and see if I can do it on my own.

This one was hard for me, but fun.

challenge_235_snaps56.yxzp

Kenda

Spoiler

challenge_235_start_file.yxmd

Qiu

Man, that is a lot of Formula...

Spoiler

challenge_235_start_file-Qiu.yxzp

DaisukeTsuchiya

Wokflow could be simplified more. Used formula is not complicatd but many tool are used.

Spoiler

challenge_235_start_file_DT.yxzp

T_Willins

Used a Cross Tab tool and a Summarize tool instead of another formula to concatenate and could have collapsed the formulas into one giant formula, but that was too difficult to debug.

Spoiler

challenge_235_solution.yxmd

jasperlch

Spoiler

challenge_235_JL.yxmd

Sashikumar

Good One.

Spoiler

challenge_235_start_file_sk.yxmd

Sashikumar

Very Easy with formula tool .

mbogusz

Impressive @LHolmes

mbogusz

I took the waterfall approach instead of writing nested IF formulas to visually see it working, and that is the beauty of Alteryx- every step of the way you can visually see what's happening and see how the sausage is made.