topic Re: Auto Selection of Files based on the user's chosen sheets using chained application in Alteryx Server Discussions

Auto Selection of Files based on the user's chosen sheets using chained application

Rao2821 — Mon, 14 Aug 2023 08:42:19 GMT

I'm seeking a way to have files automatically chosen in analytical apps, taking into account the sheet selections made by the user.

For instance:

Step 1:Actual Data

File 1

sheet 1

sheet 2

File 2

sheet 3

sheet 2

File 3

sheet 2

sheet 4

Step 2: User will Manually select sheets (At this point display all the sheet names from the files provided by the user and User should be able to select sheet names manually)

sheet 1

sheet 2

sheet 3

sheet 4

Step 3: Automation should handle the automatic selection of files within those specified sheets. Note: User should also have the choice to deselect file selections if needed.

sheet 1

File 1

sheet 2

File 1

File 2

File 3

sheet 3

File 2

Re: Auto Selection of Files based on the user's chosen sheets using chained application

ChrisWaspe — Fri, 18 Aug 2023 13:56:43 GMT

Hi @Rao2821 . You would most likely want to use a Dynamic Input tool. You can build out the file path string using the results from the various selections and configure a Dynamic Input tool to read in those files. A chained app could provide a list of the file strings after the sheets have been selected. The user could chose which of these strings they then want to pass to the dynamic input tool

Re: Auto Selection of Files based on the user's chosen sheets using chained application

Rao2821 — Mon, 15 Jan 2024 10:34:59 GMT

Thank you @ChrisWaspe,.

As a solution:
I used Directory tool and sheet name pull macro. A chained app using Tree interface tool.