Pulling muliiple excel different schema

Question

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.

macro-wf.PNG

revisedworf.PNG

apathetichell · Accepted Answer

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 apply your sheet filter logic here - and replace 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.