Import Excel array starting from a specified cell ending at an unspecified cell.

oliviercz

Hi all,

I wish to import an array form excel starting from a certain cell where i don't know the number of columns, such as this one:

Basically i wan't to know if there is an option that would resemble this:

Is there an easy way to do this in Alteryx ? (I can think of importing the entire sheet and then deleting the rows before my array, then the rows after my array and finally the columns before, but I hope there is a better way)

Thanks,

Olivier

Jonathan-Sherman

Oh I see! As far as i'm aware you can't put in an open ended reference (would love to be proved wrong!)

However, you could just read in the first line for the headers, isolate which column is your starting and ending column and push the respective column references through the input tool using a batch macro?

Kind regards,

Jonathan