I have excel files with many sheets. I would like to add a column in a sheet showing the current sheet name. How to do it in bulk?
Example as attached, I want to add a column that shows the sheet name e.g. "01 country"
Thank you.
Hi @Ringo_Wu,
I downloaded your new Excel file, renamed and it worked as intended. See below.
(I think there is a little typo in your text, because your table shows my table, but your text says '6 rows' for file 2)
I think I know what caused the error. I forgot to use the relative path in the Input Tool, and only used it in the Dynamic Input. I'll attach the changed workflow.
If you aren't familiar with relative paths: This path indicates that the input file is in the same folder as the workflow file.
Feel free to change the path in both tools as needed.
Happy weekend!
Alex
Hey @Ringo_Wu,
here is a solution to your problem:
The result looks like this:
I have attached the sample workflow.
If this solved you problem, please consider to accept it as a solution or drop another question if it doesn't.
Thanks, @grossal for your reply. Actually there is still a problem. The two different sheets contain different values. i.e. in sheet "02 Country ", there is a value of BC and DC, these values are not included in the output. It seems only the value from sheet "01 country" is included and attached to the 2 sheet names accordingly.
In fact, I wish to have output as these in one sheet:
