We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to see the number of rows that are cleaned after data cleansing tool

alteryxokan
7 - Meteor

Hello, 

 

I recently started using alteryx to show its capabilities to my management. I want to include a number showing "X amount of data cleaned" with this workflow. 

 

But I just could not find it, can you please help me? 

3 REPLIES 3
terry10
12 - Quasar

I think you'd have to calculate that yourself by comparing the data going into the Data Cleanse tool to the data going out. There are a few ways to do that. See attached workflow for one way.

 

If my reply helped you, please mark the solution as accepted.

 

Capture.PNG

 

 

alteryxokan
7 - Meteor

Thank you very much for the reply and the solution, in my data set it shows %100 of them cleansed, I don't think it is true considering I have 140k rows but will check it deeper and let you know.

terry10
12 - Quasar

@alteryxokan 

 

You are probably getting 100% based on the configuration of you data cleanse tool. If you can provide a sample of your dataset, I can help you further!

 

Please mark solution accepted if my reply helped you.

Labels
Top Solution Authors