In Alteryx, there are multiple ways to combine multiple sheets from different sources. Here are a few methods you can use:
Join Tool
If the sheets have common fields or keys, you can use the Join tool to merge them based on the shared keys. This allows you to combine the data horizontally.
Union Tool
If the sheets have the same structure and you want to stack them vertically, you can use the Union tool. It appends the rows from multiple sheets into a single output.
Append Fields Tool
If the sheets have different fields but the same number of rows, you can use the Append Fields tool. It merges the columns from multiple sheets, aligning them based on the row index.
Union Tool with Transpose
If the sheets have different structures and you want to stack them vertically while maintaining a consistent set of columns, you can use the Union tool in combination with the Transpose tool. Transpose the sheets individually, ensuring they have the same column structure, and then use the Union tool to stack them vertically.
Input Data Tool with Multiple Inputs
If the sheets are separate files but have the same structure, you can use the Input Data tool with multiple inputs. Configure each input to point to a different sheet, and the tool will combine them into a single output.
Join Multiple Tool
If you have multiple sheets with different structures but want to join them based on common keys, you can use the Join Multiple tool. This tool allows you to perform multiple joins at once, combining the data based on the specified keys.
These are just a few examples of how you can combine multiple sheets in Alteryx using different methods. The choice of method depends on the specific data and desired outcome.