This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
You could use the select records tool to specify what records you want to pull from the Excel.
Alternatively you read in a named range from the Excel. This would require the areas to be defined in the Excel document. You can use the Dynamic Input tool with the option to Modify the SQL Query > Replace a Specific String, then pass your SELECT statement there (i.e. SELECT * FROM [Sheet1$A1:B10]) to pull through specific cells.
Thanks Nick, I need three sets of data from the same excel file as attached reference files.
The solution which you have proposed seems - 3 Input Data Tools and where I need to update the select statement. Is there any other approach where I can use only one Input Data Tool and select the specific rows of data...