How add excel sheets name with Different Schema in macro.

[Shakil1]

Hello Guys,

I had created a macro to add all 40 sheets tab with different schema. But not sure how should I add the extra column with sheet name with containing all 40 sheet names in front of each row.

Request you to please help me into this asap.  Thanks!

[ed_hayter · Accepted solution]

If you have gone the batch macro route. Updating the sheetname with a control parameter. Then in the input tool in your macro go to option 4 and enable full path. From there within your batch macro before outputting you could parse the full path and pull the sheet name only.

[aatalai · Accepted solution]

in the data input tool of your macro add output file name as a field

[Shakil1 · Accepted solution]

Thank you.. it's worked.