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
