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
@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
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):
@Sebastiaandb
Thanks for your input.
Is this data range dynamic? The table size changes when this workflow is re-run with new data
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-range/td-p/654217
