ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

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

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