Input help

[vishwa1979]

Dear Team,

I have one excel and same format data is there in its sub sheet.

I want input to read all the three sub-sheet data and give me one output of all the data in one file.

Please help

Thanks in advance

[Qiu · Accepted solution]

@vishwa1979 
I can see your data schema is same for the 3 tabs, so we can use the Dynamic Input tool here.

[aatalai]

@Qiu never knew you could do it this way, I would normally bring in sheet names and file names make a new path and input that into the dynamic input tool.

There you go everyday is a school day :)

[Gaurav_Dhama_]

This is definitely an interesting solution. Great solution @Qiu.!