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:
Cheers,
Mark
Hi,
I have another question : Why I have a message like an error ?
My configuration is :
Thanks a lot for your help.
Regards,
Psyrio
Maybe the metadata is not loaded?
Try to run the workflow and see if message persists.
It's not works and create an error of execution of my workflows but it have pass my data I don't understand 😞
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
@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
Thanks for this return and for your help 🙂 and for your formidable work too !
Regards,
Psyrio
Hi Marquee,
I am having issue downloading the macro package. Can you please re-send the new link?
Thank you
https://gallery.alteryx.com/#!app/CReW-Cleanse/5fdb6ad60462d71998cebc8a
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?