How to join tabs within an excel report after a batch macro

[Hi2023]

I did a Batch Macro to pull 8 excel reports tpgether and Those reports have 4 tabs within. Now I need to join those 4 tabs together using  the control#. How do I do a filter on sheet name after -it only give me column name now.

thanks

[gautiergodard]

@Hi2023 Could you perhaps alter your macro so that a full path is added to each row of data? From there you should be able to parse out the sheet name

[Hi2023]

hmm I got help with the macro so not sure how to do that

[BrandonKO]

In your Input Data tool, you can select "Output File Name as Field" which will include the full path as a field. From there you can parse out the sheet name with a Formula Tool. 

[Hi2023]

I used the Directory Tool Input?

[binuacs]

@Hi2023 can you provide some dummy data and expected output?

[Felipe_Ribeir0 · Accepted solution]

Hi @Hi2023 

Try the attached workflow.

[Hi2023]

TY!