Remove null column dynamically

[Mhnd]

Hi,

I have 6 excel files each one has one or more sheet, i end up with 14 sheets, so i need to input all these sheets (different schema) at once, each week, for that reason I create batch macro contains the input files and output macro, this was help but cause more than 16000 column, I cant use cleanse tool because i have to select columns and there is no "dynamic or Unknown column". So, I figure out the Multi field formula could help to remove null columns at once but i don't know how to use it and write an expression like if isNull([_CurrentField_]) then remove it.

Thanks

[binuacs · Accepted solution]

@Mhnd The data cleansing tool should work even though you did not select any columns

[Mhnd]

I spent two days searching. Thanks a lot