Challenge #142: Life Certainties - Workflows, Death, and Taxes

[sprodger]

Spoiler

my solution, like others, decided to use the arrange tool :). probably could have used a few less tool overall though. 

[SrideviB]

started looking in to Alteryx only a few weeks back and my 1st ever workflow challenge.. Thanks for keeping everything so organized in the community.. from learning material, challenges and training.   Thanks, Sri

[JoeS]

I used the arrange tool too. In 10 years of using Alteryx it's the first time I have used it to solve something, previously I have only used it to see what it did.

Managed to get the solution down to 4 tools as well, which I was pretty happy with!

Spoiler

[JoeM]

@GarthMiles - that's a hot tip I haven't heard before! In all candor, I still whip out the help when I have to use this tool as well.

[wenjuanchen]

@NicoleJohnson Love your super cute icon, and your icons for other macros!

[wenjuanchen]

Solution attached. Had fun solving it. Trying to put a better icon for the macro this time:)

Thanks @JoeM for sharing this challenge!

Spoiler

Spoiler

[OliverW]

As a Solutions Engineer who likes to think of easiest solutions, no Macro, no hard path,  just simple Alteryx functions (and a little RegEx for some extra spin.

Spoiler

[KevinW]

Went with the easy path as I wasn't trying for the style points this morning - just get 'r done.

Spoiler

[Pollution]

Not the most elegant solution but it'll work

Spoiler

[Carter_McGary]

No need to even touch the 'companies' input :)