Remove Empty Columns

[DelData]

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

[binuacs · Accepted solution]

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

[ChrisTX · Accepted solution]

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 

[DelData]

Excellent.....thank you for your help.....this fixes my problem and helps me a lot.....thank you for taking time out to fix :)