We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Data Cleansing tool - add option to ignore/exclude selected field(s) for Remove Null Rows

The Remove Null Rows feature added to the Data Cleansing tool is really nice, however it doesn't work for a common use case for us where we have key metadata field(s) added to the data stream that make rows not null so we'd like to be able to ignore or exclude one or more fields from the Remove Null Rows output.

 

Here's a use case starting with an Excel file with multiple tabs where each tab holds the records for a different Province:

 

Screen Shot 2020-06-17 at 9.39.17 AM.png

 

 

Note that the 2nd record in Southern is entirely empty, so this is the record that we'd like to remove using the Data Cleansing tool.

 

Since the Province name is only in the worksheet name (and not in the data) I'm using a Dynamic Input tool with the "Output File Name as Field" to include the worksheet name so I can parse it out later. So the output of the Dynamic Input looks like this:

 

Screen Shot 2020-06-17 at 9.46.34 AM.png

 

With the FileName field populated the entire row is not Null and therefore the Remove Null Rows feature of the Data Cleansing tool fails to remove that record:

 

Screen Shot 2020-06-17 at 9.48.24 AM.png

 

 

Therefore what we'd like is when we're using the Remove null rows feature in the Data Cleansing tool to be able to choose field(s) to ignore or exclude from that evaluation. For example in the above use case we might tick the "FileName" checkbox to exclude it and then that 2nd row in Southern would be removed from the data.

 

There are workarounds to use a series of other tools (for example multi-field formula + filter + select) to do this, so extending the Data Cleansing tool to support this feature is a nice to have.

 

I've attached the sample packaged workflow used to create this example.

2 Comments
KylieF
Alteryx Community Team
Alteryx Community Team

Hello! Thank you for your feedback and such a thorough explanation of your use case. If you haven't yet, be sure to look over our Submission Guidelines which go over the idea boards process in a bit better detail. However your idea overall looks good to go once the necessary criteria have been met.

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes