This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
2022.1.1.30569 Patch Release Update
The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs.
If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.
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?
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.