topic Re: MarqueeCReW is getting "down & dirty" with Data Cleanse in General Discussions

MarqueeCReW is getting "down & dirty" with Data Cleanse

MarqueeCrew — Tue, 29 Dec 2020 15:57:10 GMT

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

Re: MarqueeCReW is getting "down & dirty" with Data Cleanse

Ian_Johnson — Mon, 04 Jan 2021 10:47:01 GMT

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

Re: MarqueeCReW is getting "down & dirty" with Data Cleanse

MarqueeCrew — Mon, 04 Jan 2021 19:02:50 GMT

@Ian_Johnson ,

That does make sense. @Aguisande could you please confirm and I'll update the gallery version.

Cheers,

Mark

Re: MarqueeCReW is getting "down & dirty" with Data Cleanse

Aguisande — Mon, 04 Jan 2021 22:26:08 GMT

Will test that ASAP and let you know.

Best,

_AG_

Re: MarqueeCReW is getting "down & dirty" with Data Cleanse

Aguisande — Mon, 04 Jan 2021 23:10:18 GMT

This is the change I made (I hope it's exactly what @Ian_Johnson was pointing:

Reviewed the results, and it's OK. Also, I noticed an improvement in the execution time, against the previous version.

Awesome job Mark! (And Ian too!)

Best

Re: MarqueeCReW is getting "down & dirty" with Data Cleanse

Ian_Johnson — Tue, 05 Jan 2021 10:12:01 GMT

Yes that's all I did locally too.

Fantastic work from you guys

Re: MarqueeCReW is getting "down & dirty" with Data Cleanse

MarqueeCrew — Wed, 06 Jan 2021 15:20:05 GMT

@Ian_Johnson ,

Thanks for your attention to the function. I had incorporated the "original" logic as-is. I opted for a different solution however. I burdened the HTML removal logic with TRIM and Replace multiple whitespace logic instead of moving the detours around. While they are very portable (architecture feature), I want the logic to flow with parallelism to the current Alteryx macro. Also, I don't want to need to explain that in order to do HTML cleanup, you need to choose the other too.

Version #10 is on the gallery now.

Cheers,

Mark

Re: MarqueeCReW is getting "down & dirty" with Data Cleanse

psyrio — Sat, 06 Feb 2021 11:51:13 GMT

Hello,

Sorry but how I need to install this macro please because I have the CreW Macro package install and when I launch the CReW+Cleanse.yxzp the CReW tool not appear in my tool menu in ALTEYRX. I have only a directory CReW+Cleanse create where I have launch my CReW+Cleanse.yxzp

Sorry for the question 😞

Regards,

Psyrio

Re: MarqueeCReW is getting "down & dirty" with Data Cleanse

Aguisande — Sat, 06 Feb 2021 13:34:39 GMT

Hi @psyrio

If you installed the Cleanse macro, it should appear in the Preparation Category.

Re: MarqueeCReW is getting "down & dirty" with Data Cleanse

psyrio — Sat, 06 Feb 2021 13:41:10 GMT

Hi @Aguisande ,

Thanks for your answer. It's not work for me. When I execute the package in my Desktop server, it's appear a directory CReW+Cleanse but it's not appear automaticly in ALTERYX.

I have found a detour : Add in my ALteryx User Setting in Macro the directory in my desk.

It's more easy if they they can be install automaticly like the CReW Package macro of 2019.

Regards,

Psyrio

Re: MarqueeCReW is getting "down & dirty" with Data Cleanse

psyrio — Sat, 06 Feb 2021 13:43:49 GMT

Hi,

I have another question : Why I have a message like an error ?

My configuration is :

Thanks a lot for your help.

Regards,
Psyrio

Re: MarqueeCReW is getting "down & dirty" with Data Cleanse

Aguisande — Sat, 06 Feb 2021 14:11:06 GMT

Maybe the metadata is not loaded?

Try to run the workflow and see if message persists.

Re: MarqueeCReW is getting "down & dirty" with Data Cleanse

psyrio — Sat, 06 Feb 2021 14:26:33 GMT

It's not works and create an error of execution of my workflows but it have pass my data I don't understand 😞

Re: MarqueeCReW is getting "down & dirty" with Data Cleanse

psyrio — Sat, 06 Feb 2021 14:30:08 GMT

It's works now.

I have check the proportie

Remove manualy the

and unckeck

Now I don't have the error.

Thanks for your help.

Regards,

Psyrio

Re: MarqueeCReW is getting "down & dirty" with Data Cleanse

MarqueeCrew — Sat, 06 Feb 2021 15:12:19 GMT

@psyrio & @Aguisande ,

I've updated the macro. https://gallery.alteryx.com/#!app/CReW-Cleanse/5fdb6ad60462d71998cebc8a

The default for the convert Nulls to blanks were selected by default. You couldn't see them checked because the outer select box was unchecked. We've de-selected them.

In review of the macro I also saw 2 other potential issues that were addressed. I think that one of them exists in the Alteryx macro.

Testing... Testing... Testing

Thanks for making us aware of the issue.

Cheers,

Mark

Re: MarqueeCReW is getting "down & dirty" with Data Cleanse

psyrio — Sat, 06 Feb 2021 15:20:22 GMT

@MarqueeCrew @Aguisande

Thanks for this return and for your help 🙂 and for your formidable work too !

Regards,

Psyrio

Re: MarqueeCReW is getting "down & dirty" with Data Cleanse

CW5 — Fri, 19 Mar 2021 19:05:55 GMT

Hi Marquee,

I am having issue downloading the macro package. Can you please re-send the new link?

Thank you

Re: MarqueeCReW is getting "down & dirty" with Data Cleanse

MarqueeCrew — Fri, 19 Mar 2021 19:12:10 GMT

https://gallery.alteryx.com/#!app/CReW-Cleanse/5fdb6ad60462d71998cebc8a

Re: MarqueeCReW is getting "down & dirty" with Data Cleanse

MI1 — Thu, 14 Oct 2021 12:17:23 GMT

Macro is great is faster 🙂 .........however is there any way to make it dynamic when including the function ALL Fields ? as I am using a macro merging muliplte Excel where unfortunately I alsways get different header in each run.....?

Any little helps on this challenge?