Dynamic input with multiple excel

[kobetse]

Hi All,

I have multiple excel file with tab name name but in same structure, and wanna input them

e.g.

1/ daily sales report_20230606, tab name: sales_20230606

2/ daily sales report_20230607, tab name: sales_20230607

3/ daily sales report_20230608, tab name: sales_20230608

4/ daily sales report_20230609, tab name: sales_20230609

*All of them are in same structure*

Can anyone please advise how to input them?

I knew that we could use "*" wildcard to input them if the file name structure is same,

however the tab name is different, and wildcard is not applicable to selected range

Thanks!

[flying008 · Accepted solution]

Hi, @kobetse 

Input + Formula + Dynamic Input  = get your want:

1- Input date data:

2- Formula of Field [Path]:

"D:\Test\" + 'daily sales report_' + ToString([Date]) + '.xlsx|||`sales_' + ToString([Date]) + '$`'

Date	Path
20230606	D:\Test\daily sales report_20230606.xlsx|||`sales_20230606$`
20230607	D:\Test\daily sales report_20230607.xlsx|||`sales_20230607$`
20230608	D:\Test\daily sales report_20230608.xlsx|||`sales_20230608$`
20230609	D:\Test\daily sales report_20230609.xlsx|||`sales_20230609$`

3- Dynamic Input :

4- Run !

[kobetse]

It works!! Thank you so much! ;')