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

[psyrio]

Hi,

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

My configuration is : 

Thanks a lot for your help.

Regards,
Psyrio

[Aguisande]

Maybe the metadata is not loaded? 

Try to run the workflow and see if message persists.

[psyrio]

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

[psyrio]

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

[MarqueeCrew]

@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

[psyrio]

@MarqueeCrew @Aguisande 

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

Regards,

Psyrio

[CW5]

Hi Marquee,

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

Thank you

[MarqueeCrew]

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

[MI1]

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?