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 have a requirement in which we need to get user selected row from an opened excel sheet, then i need to create a new excel file with the selected data from opened excel sheet mention before. I have done lot of try but didn't get a solution. Can anybody let me know how to resolve the same?
You will not be able to do this dynamically based on the selected row in an opened sheet, primarily because Alteryx will not read the data from a sheet that is currently opened... but you could implement an app, and use Select Records tool. See attached for an example. The Select Records tool allows you to specify a certain row, or a range of rows, in your data. So the user could pick the row they'd like to use and then that row will be output to another file. Alternatively, you could add a column in your Excel sheet where the user could put an "x" in the row they'd like to use, save & close the spreadsheet, and then Alteryx can filter the sheet to only output row(s) that have an "x" in them?