Hello, I am still new to alteryx. I receive this workflow and I have to modify and simplify it especially at the "find and replace" tools. Please advise me on how to simplify them and some other messy tools, and suggest me which tool is suitable to use.
Thanks.
Solved! Go to Solution.
Under OPTIONS there is a menu choice for EXPORT WORKFLOW. If you export with data, we could receive a package that is a functioning workflow with data.
Observation Notes:
IF FindString([[SAD]]Commodity (Commodity)], "INACTIVE_DO NOT USE_")>-1 THEN Substring([[SAD]]Commodity (Commodity)],20) ELSE [[SAD]]Commodity (Commodity)] ENDIF
IIF(Contains([[SAD]]Commodity (Commodity)], "INACTIVE_DO NOT USE_"),Substring([[SAD]]Commodity (Commodity)],20),[[SAD]]Commodity (Commodity)])
IIF(Contains([_CurrentField_],"INACTIVE_DO NOT USE_"),Substring([_CurrentField_],20),[_CurrentField_])
Replace([_currentField_]),",",'')
Now I get to the joins and find/replace in the workflow and would really benefit from seeing the data. I think that transposing the data and performing the lookups all at once is the approach that will simplify and streamline the workflow. If you package this up, I (or someone in the community) will likely jump at the opportunity to help.
Cheers,
Mark
Unfortunately I could not share the data to public and I have tried to simplify them but it does not work. Maybe you can suggest me any other alternative way to solve this problem especially in the bunch of Find/Replace tools