Multi Field Formula – The Analytics Corner

Remove Columns with Zeros or Nulls from Alteryx Workflows

by Julie Sebby
December 23, 2020
Alteryx, Using Specific Tools
4 Comments

Last week, I wrote a post showing how the Auto Field tool could be used to reduce the size of data sets. This week, I’m going to show how the same tool can be used to programmatically remove columns with zeros or nulls. This can also help reduce the size of your data sets and get rid of columns. Read on to learn how.

How to Reduce the Size of an Alteryx Data Set

by Julie Sebby
December 10, 2020December 10, 2020
Alteryx
3 Comments

I love that I can run huge amounts of data thru Alteryx. However, I also have to think about how much data I’m going to take from Alteryx and push to a BI application like Spotfire or PowerBI. As a general rule, less is more. Now, you may think you can’t do anything to reduce the size of your data set without cutting columns or rows, but that’s not true. Read on to learn two quick tricks to materially reduce the size of your data set.