Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Spoiler
I really like your solution and tried to recreate part of it on my own. However, for the Action tool connected to the Select tool, it doesn't show all the fields. It shows "Unknown" instead. Did I miss anything?
Thank you very much @NicoleJohnson for such an data cleaning series... Much needed exercise as I am learning and trying for Alteryx Advanced Certification...
Spoiler
Workflow:
Spoiler
Macro:
What a blast! See my solution below.
Spoiler
I tried to create a macro that would be as dynamic as possible. However, I couldn't figure out how to deal with Debit/Credit or Currency Code fields, because if these are not present in a dataset, macro would not work as intended. Otherwise seems like I managed to address the most common scenario, i.e. what if a report is enhanced with additional fields (credit line limits or closing balances) that have to be converted to USD.
