We are aware of an issue with the Search bar. Please use Advanced search for the time being while we troubleshoot. Thanks for your patience as we work on improving the community!

General Discussions

Discuss a wide range of topics! Questions about the Alteryx Platform should be directed to the appropriate Product discussion forum.

MarqueeCReW is getting "down & dirty" with Data Cleanse

MarqueeCrew
19 - Altair
19 - Altair

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.

 

capture.png

 

PowerPoint Presentation describing CReW Cleanse Data macro journey:

 

Review of CReW Cleanse Data (using Alteryx):

 

Location of Macro:

CReW Cleanse Macro 

 

Cheers,

 

Mark

 

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Please Subscribe to my youTube channel.
17 REPLIES 17
psyrio
9 - Comet

Hi,

 

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

psyrio_0-1612618982285.png

 

My configuration is : 

psyrio_1-1612619004672.png

 

Thanks a lot for your help.

 

Regards,
Psyrio

Aguisande
13 - Pulsar
13 - Pulsar

Maybe the metadata is not loaded? 

Try to run the workflow and see if message persists.

 

psyrio
9 - Comet

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

psyrio_0-1612621542743.png

 

psyrio_1-1612621576886.png

 

psyrio
9 - Comet

It's works now.

 

I have check the proportie

 

psyrio_0-1612621727531.png

 

Remove manualy the 

 

psyrio_1-1612621751327.png

 

and unckeck 

 

psyrio_2-1612621767003.png

 

Now I don't have the error.

 

Thanks for your help.

 

Regards,

Psyrio

 

MarqueeCrew
19 - Altair
19 - Altair

@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

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Please Subscribe to my youTube channel.
psyrio
9 - Comet

@MarqueeCrew @Aguisande 

 

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

 

Regards,

Psyrio

CW5
5 - Atom

Hi Marquee,

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

 

Thank you

 

 

MarqueeCrew
19 - Altair
19 - Altair

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

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Please Subscribe to my youTube channel.