dynamically remove null columns

[MartWClimber]

So I've got a workflow that gets information from different folders to check if data is there or not.

the data because of different folders sometimes got as a result some null columns.

is there a way to remove null columns via the dynamic select? because right now the staticfilter field is a null column but if I dynamically switch to an other folder this column is filled with data.

see bellow for an example of input and desired output

ReloadType	OutputFileName	LastExecution	FileName	StaticFilter
Increment	outputname	19/11/2022 00:00	Filename

output

ReloadType	OutputFileName	LastExecution	FileName
Increment	outputname	19/11/2022 00:00	Filename

[Kakuffo · Accepted solution]

 @MartWClimber  the Datacleanse tool has an option to remove full null rows or columns

[ShankerV]

Hi @MartWClimber 

If I understand your requirement correctly, you want to remove the column which has null of [null] values.

You donot want to display the column in your output right?

Many thanks

Shanker V

[binuacs]

@MartWClimber One way of doing this

[gautiergodard · Accepted solution]

Hey @MartWClimber 

You can select the "remove null columns" options within the data cleanse tool.

Another option I've used in the past is the attached macro.

[ShankerV]

Hi @MartWClimber 

Here is an use case for your reference.

Input: 

Output:

You can do more with data cleansing tool.

https://help.alteryx.com/2019.2/DataCleansing.htm?TocPath=Tools%7CTool%20Categories%7CPreparation%7C....

Many thanks

Shanker V

[MartWClimber · Accepted solution]

Data cleaning tool was the solution. I wanted a way to difficult solution. but most of the times think simple :) 

anyway it works now. all the solution with data cleaning tool thx