Eliminating a column if it has a null value

Hello,

Due to company policy I cannot post workflows or data. I have PDF of the workflow at the relevant point.

If you see a null in the column it's because it failed a criteria. I need to eliminate those columns. I originally tried to use Auto-field to reduce to the smallest data size and then eliminate those, but that only eliminated entities that didn't match a list. The two rows at the bottom may have information in them that makes the whole column INT16 or INT32.

I also thought about a filter but I can't have a filter that lists all columns because there are too many and they will also change in number.

Any help is appreciated.

Capture.pdf

Datasets

Custom Tools

Dynamic Processing

Preparation

Accepted answers

All comments

AngelosPachis

Hi @dogregory ,

Which version of Alteryx are you on?

dogregory

@AngelosPachis 2020.4 X64

echuong1

The data cleansing tool will actually profile and remove any column/row that is entirely null if you check off the option.

dogregory

@echuong1 Will this work if there is data in the column, but it also has nulls?

SeanAdams

Hey @dogregory

if you use a transpose tool, it changes all columns to rows. This adds two columns called "Name" and "Value"
You then filter for which have null values - and name of the column will be in the "Name" column in your data set
- and if you use a unique - you can quickly find the offending columns
Now you can either:
- Crosstab this back to rows and columns
- Or use something like the Dynamic Select (on the original dataset) to dynamically remove columns

🙂 this is a great use for Transpose

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703