File Browse to bring in two tabs

[jonnybruce]

Hi,

I would like to use the File Browse tool but bring in two separate sheets in separately from this one file browse tool, is this possible? The file name may change however the sheet names will always be the same. 

[ShankerV]

Hi @jonnybruce 

The file browse tool is used to select the directory.

Then all the files from the directory will be read. 

Then we can apply the logic to filter which file to read, then all the sheets in the filename which will change dynamically can be read.

FYI, even if the sheet name also changes you can read.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @jonnybruce 

I have an use case to explain below.

As per the below screenshot, it helps to select any filetype

Select any one file you want to select,

In this please use the option highlighted.

[gabrielvilella]

Hi @jonnybruce, it is possible. You can have one File Browse connected to multiple Input Data, and one Action for each with this formula:

Regex_replace([#1],'(.+\|).+','$1')+Regex_replace([Destination],'.+\|(.+)','$1')

This way, it will not matter what is the Sheet Name that the user selects, it will always get the sheet name from the connected Input Data.

[jonnybruce]

Hi, how would I then load in the sheets though?

[gabrielvilella]

Is this a question for me?