Input tool bringing in extra null columns from Excel named range

I am using a named range to pull in data from an .xlsm file and am getting 29 extra null columns named F1 through F29) coming in before my actual columns defined in the named range. The excel file is macro enable but I tried saving it as and .xlsx file and am still have the same issue. Any ideas?

Input

Accepted answers

CharlieS

The definition looks good. Try using the Excel Legacy driver instead of the regular Excel. The built-in driver can do some odd things to field types (and therefore values) when importing.

All comments

CharlieS

This is something that I see a lot and it's easy to resolve. From what I can tell, if there was every anything in those fields (even if they're blank now) they're flagged as modified and Alteryx will import them.

To prevent those empty columns from being pulled into Alteryx, open the sheet in Excel and Delete the columns (not just empty the contents). Select the columns, right click, and delete. The keyboard shortcut is Alt+E, D.

mariahmeehan

Hi Charlie,

Thanks for the quick response. The reason I'm using a named range is because there is data in the columns to the left that I don't need for this workflow but also can't delete. The named range only refers to the columns I need so I'm not sure why the whole sheet is being pulled in.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335