How add excel sheets name with Different Schema in macro.

Question

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 Answer

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 Answer

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

Shakil1 · Accepted Answer

Thank you.. it's worked.