XLSB file: Start Data Import on Line #

[YLYONG]

Hi Alteryx Community,

Need your help to on this: 

How can we specify "Start Data Import on Line 7" for a xlsb file?

Thank you

[Sebastiaandb]

@YLYONG 

Hi! If you drag you xlsb file to your workflow canvas, you have the option to give it a data range before loading :-). 

You can also edit the input file if it's already in the canvas 🙂 (see the range in the table/query part):

[messi007 · Accepted solution]

@YLYONG,

It's not allowed with the input data tool.

But you can do it with sample and dynamic rename tool.

Please see below:

Attached the workflow.

Regards

[YLYONG]

@Sebastiaandb 

Thanks for your input.

Is this data range dynamic? The table size changes when this workflow is re-run with new data 

[Sebastiaandb]

@YLYONG 

It's not dynamic. Sadly enough Alteryx will not recognize tables in Excel as that would make it dynamic, the named ranges in combination with a table don't work for Alteryx (as that would make the named range dynamic). Therefore, @messi007 solution would be your option to go :-). More explanation:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Can-Alteryx-input-excel-dynamic-named-...