read data from one of excel sheets

[yuanlu]

I have a Excel file (attached) with 2 sheets (or more), I have 2 workflows need to read from  sheet 1-62 and sheet 63-74 respectively. Is there a way to have these 2 workflows connect to the same data input tool with this same Excel file, but each workflow reads its own data sheet?

[Qiu]

@yuanlu 
My understanding is that if the tools are in the same canvas, it is one workflow.
So maybe you are looking for chaining workflow?

https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Chaining-Workflows-Together/ta-p/3857...

[apathetichell · Accepted solution]

Hi -  I think whatever you are trying to do can be accomplished with a batch macro which is called in two distinct workflows. In workflow one the control parameter tells it to find sheets 1-62 and in workflow two the control parameter tells it to use 63-74.