How to load in multiple worksheets from the same Excel file with a different range

Question

Lets say I have an Excel Worksheet with 10 worksheets, and I want to read in 5 out of the 10 worksheets. Each of the worksheets also has a different range of cells I want to specify instead of reading in the whole worksheet. Is there an easier way of doing this ithan using one input tool per worksheet? Thanks!

overhead_press · Answer

Hi I am on version 2021.3.3.63061!

Jonathan-Sherman · Answer

Hi @overhead_press,

Which version of Alteryx are you running? As there's some new(ish) features that help you to pull in ranges (and could probably be combined with a batch macro) that would be very useful in this kind of scenario!

Kind regards,

Jonathan