34|ALTERYX – Audit Attention

[Andrew_Winder]

[Emily_Johns]

This was a good learning experience!
TechHub Nov3.yxmd (40.1 KB)

[Gabby_Wilson]

Here’s my solution.

[Colton_Bullock]

Here is my best shot at this problem!

[Skyler_Lucas]

AuditAttention.yxmd (18.4 KB)
I liked this one. Good exercise for Alteryx and Audit!

[Maddy_Bunn]

Thanks for the fun challenge! Here’s the solution I got.

AuditChallenge.yxmd (15.2 KB)

[Tate_Tingey]

TechHubChallenge34.yxmd (14.8 KB)

[Allison_Fischer]

Fun! I got messed up with strings and doubles but it was a quick fix that I was able to recognize on my own!
34Problem.yxmd (14.4 KB)

[Keilani_Hess]

Here’s my solution to the problem

TechHub_Audit_Attention_Challenge.yxmd (31.2 KB)

[Julian_Guajardo]

For my solution, I filtered a little bit differently from the posted solution. Instead of using a formula tool to transform some of the values to their the absolute value, I just set the filter to find ending debit balances less than or equal to -50,0000.

SolutionChallenge34.yxmd (14.1 KB)

[Sydney_Livingston]

This was really great practice for using an inner join.

[Henry_Molina]

Here is my solution to the problem. I didn’t use the absolute value, I just made a clause that it could also be less than -50000… Hope that still counts haha.

[Michelle_Semadeni]

I’m still getting the hang of alteryx, so this was a helpful challenge!

Instead of using the formula tool to find the absolute value for the debit/credit balance, I used an advanced filter tool and sorted for where the balance was <= -50000 OR >= 50000

Audit_Attention.yxmd (17.1 KB)

[Matthew_Layden]

Heres what I came up with, really fun challenge

[Keyyan_Lugo]

Challenge34_KeyyanLugo.yxmd (15.2 KB)
Here is my solution to this problem!

[Jill_Davis]

Here’s my solution!

[Braedyn_Gray]

Here’s my solution. Great challenge!

[Melissa_Fales]

probs78techhub.yxmd (12.2 KB)
Great challenge!

[James_Gerstner]

Here’s my solution! I used an “OR” in my filter to find the credit and debit balances instead of an absolute value.
Challenge34_Audit_Attention.yxmd (16.5 KB)

[Jaxon_Floyd]

This was a good one! I am still new to Alteryx, so this was good practice. I got eight rows–which may not be correct. But here is my workflow.