MarqueeCReW is getting "down & dirty" with Data Cleanse

MarqueeCrew

Have you wondered what goes into making a CReW macro?  Here's a little insight into the process.  I've created a video that expands on my presentation of the macro (delivered to Alteryx User Groups) for you to watch at your convenience.  If you've got questions, comments or feedback please reply to this post.

PowerPoint Presentation describing CReW Cleanse Data macro journey:

Review of CReW Cleanse Data (using Alteryx):

Location of Macro:

CReW Cleanse Macro 

Cheers,

Mark

Ian_Johnson

Feed back..........I love it, I love it, I love it 😁

Some great speed improvements.

One things I have changed locally is to move the Remove HTML Tags to before the Remove Unwanted Characters in the running order.

I found that the way that you originally had it left whitespace that needed a second data cleanse to tidy up

Do you see any issues with this change that I may not have seen on my initial testing?

Thanks

Ian