Remove NULL Columns - 2019.4

suby

Hi All,

I believe in the recent version of Alteryx you have the option to remove NULL columns on the Dat cleansing Tool.

We are in 2019.4 and i have some NULL values coming through and my requirement is to completely remove the NULL columns from the Data stream any thoughts.

AngelosPachis

Hey @suby ,

You can transpose your data and then filter out the null values. For columns that are 100% null, that will remove all records, and hence when you cross tab back to the original table structure those columns will not be there

Input :

Output:

Hope that helps,

Angelos

example.yxmd