Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

General Discussions

Discuss any topics that are not product-specific here.

MarqueeCReW is getting "down & dirty" with Data Cleanse

MarqueeCrew
20 - Arcturus
20 - Arcturus

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 restart. 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
15 - Aurora
15 - Aurora

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
20 - Arcturus
20 - Arcturus

@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 restart. 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
20 - Arcturus
20 - Arcturus

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

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. 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?

Labels