It is very easy to input data from multiple sheets in Alteryx. Here’s a short tutorial on how to do it:
- Inside Alteryx's workflow designer, head over to the left-side panel and find 'Input Data'. Drag this tool onto the canvas to make further configurations.
- Following that, go to the right-hand panel and click 'Upload Data'.
- Tap 'Choose File' and then select the XLSX file that contains the data you want to use.
- Following that, click the 'Dataset Creation' menu and choose 'Selected Sheets'. If you want to use all the sheets in your XLSX file, set it to 'All Sheets' instead.
- Subsequently, click the 'Select Sheets' menu and then choose all the sheets you want to use.
- Once done, click 'Create Dataset'.
- Finally, the data from the selected sheets will be entered into your Alteryx workflow.
