Pulling muliiple excel different schema

[samson211]

Using this it seems working, however I want to bring few things here.

1. Sometime sheet name might not be exactly same, so can I define a condition to pull data from like this named sheet , something like that.

2. If file name dont exisit just skip it. I think maybe already getting done.

3. I also want additional column, where it will give me name of the file from which the rows are getting picked

Any leads would be appreciated. sorry being noob.

[apathetichell · Accepted solution]

you can do what you want. 

1) outer workflow - > you have this.

2) first inner workflow - now named outer macro -> grab the excel sheets via <List of Sheet Names> 

apply your sheet filter logic here - and replace <List of Sheet Names> with the sheets you want.

3) new inner macro - replace the excel file location with the filename/sheetname you chose above. use a macro output. interface designer to accept different schema. apply your filter logic here.

4) macro output from your new inner macro to your outer macro-> use another macro output to send to your main workflow. configure interface designer as described above.