Oh no! The Community appears to be haunted! Help us find all the spooky specters here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

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.
18 REPLIES 18
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
14 - Magnetar
14 - Magnetar

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.
MI1
7 - Meteor

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?