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.
I was wondering if there is a way to use only one File Browse in an Alteryx app, and use that to update two different input tools with two different sheets? I am using multiple sheets from one input file and I don't want the user to select the sheets individually with different File browse options. The schema in each sheet is different. I don't want to combine them either. I only want to reduce the number of File browse tools used. Any solution?
@mceleavey I'm not entirely sure of how this works here. But my idea is to take in a file path using file browse, and use that path with 2 different (static) sheet names on two inputs. But I do not require the sheets to be union-ed together. Also, the individual sheets do not have the same schema.
@mceleavey But this uses 2 different file browse tools, right? My objective is to use the same file browse tool for 3 different input tools (same file, 3 different sheets). In other words, reduce three file browse tools to one tool.
I mean, I know this is getting confusing, but thank you for your help! 🙂
I was able to resolve this myself eventually. All I had to do was take in a file browse and configure the action tool to only replace the file path (and not the sheet name) and take in only list of sheets, followed by a dynamic input to read the individual sheets. As a result, the user only needs to select the file path and not sheet name in the File browse!