dynamically remove null columns

Question

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

ReloadTypeOutputFileNameLastExecutionFileNameStaticFilterIncrementoutputname19/11/2022 00:00Filename

output

ReloadTypeOutputFileNameLastExecutionFileNameIncrementoutputname19/11/2022 00:00Filename

KAkuffo · Accepted Answer

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

gautiergodard · Accepted Answer

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.

MartWClimber · Accepted Answer

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