I've been using Alteryx for about 2 years. I recently drafted a workflow that leverages the Find Replace tool to normalize vendor names for matching and other purposes. For example one vendor might put Company in one system and CO in another. My workflow ensures that Company is always CO and Corporation is CORP etc., I want to create a macro for this. I've had success with batch and iterative macros. Seems this should be a standard macro but I can't seem to get it to function. I've uploaded my macro and the file I leverage for normalization.
I want this macro to simply accept a field of choice with the address information in it, perform the normalization, and pass the rest of the data through untouched. Seems like this should be pretty simple but I'm stuck?
Please and Thankyou
TheGoatleyOne
