Remove Empty Columns

Question

Hi There,

Can anyone help me to remove empty columns?

I know i can use the cleansing tool to remove NULL columns....see null columns.png...but cleansing tool does not work for empty columns

Sometimes though with transpose or other reasons i end up with empty columns like columns aaa,bbb and ccc i manually added in to show problem in empty columns.png

Is there a way to remove all empty columns from my data set when this happens....

I have attached pics and data needed to help....with solution....thank you

null columns.png

empty columns.png

delboy remove empty columns.yxmd

delboy empty columns.xlsx

binu_acs · Accepted Answer

@DelData Data CLeansing tool removes only the NULL columns, not the empty ones, attaching a workaround for your solution

ChrisTX · Accepted Answer

Before using the Data Cleansing tool to remove null columns, use a Multi-Field Formula tool with expression

IF IsEmpty([_CurrentField_]) THEN Null()
ELSE [_CurrentField_]
ENDIF

Chris