File name not capturing for each file

[spsanu_EY]

Hi All,

I am new to this community so not sure If I am posting this under right topic. 

Problem:

I am trying to stack multiple excel file into one output file, for that I am using batch Marco and created one workflow, picture given below

Problem I am facing is when I am stacking multiple excel files using above batch marco, dont know why only first file is getting captured, though data is getting populated for all the excel files.

   Instead of only "April2016" I should have all different period name here.

Thanks for your help in advance. Workflow also added.

Thanks & Regards,

Satya Prakash 

[patrick_digan · Accepted solution]

@spsanu_EY You will want to change your action tool. Notice that the Input tool's data in the top section has April2016 but the replace text in the bottom has April2017. You should presumably change the bottom one to be April2016. And if you're truly replacing everything (sheet name and all), you're better off just unchecking the bottom part. That way it will just overwrite no matter what.

[spsanu_EY · Accepted solution]

Hi Patrick,

Thanks a lot for your reply, it was really helpful and solved the problem.

Satya