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]

Hi @oliviercz,

This feature was released in 2020.1, you can find more details here: https://www.theinformationlab.nl/en/2020/03/10/alteryx-2020-1-is-available-whats-new/

(Also attaching 2020.1 Alteryx official release notes: https://help.alteryx.com/release-notes/designer/designer-20201-release-notes)

Kind regards,

Jonathan

[oliviercz]

Thanks, but don't think it solves my issue, I don't know what column to put for the ending cell of the array

[Jonathan-Sherman · Accepted solution]

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