I'm somewhat new to Alteryx, and I'm stuck on inputting excel files correctly. My goal is to utilize the File Browse tool so that the user of the app/workflow can select/input a new file when it is run. While the files inputted may differ each time, the format will always be the same. This file will have multiple tabs, but I only want to read in two tabs (the name of these 2 tabs will always be the same no matter which file is selected, let's say the two tabs are named X1 and X2). The goal is to take each tab and perform cleansing and manipulation on the two tabs separately, and then union them back in the end. How can I set up the File Browse -> Input Data (or Dynamic Input) to take in a new file each time, connect them to an input tool, and take the same two tabs to clean/manipulate them?
I am using Alteryx Version 2020.6.4